Re: Table name lengths...
От | Chris Bowlby |
---|---|
Тема | Re: Table name lengths... |
Дата | |
Msg-id | 1062523977.97203.33.camel@morpheus обсуждение исходный текст |
Ответ на | Re: Table name lengths... (Richard Huxton <dev@archonet.com>) |
Ответы |
Re: Table name lengths...
Re: Table name lengths... |
Список | pgsql-general |
On Tue, 2003-09-02 at 14:24, Richard Huxton wrote: I'm working with an application that needs to be able to determine this depending on the version of PostgreSQL that is running. I know what anything less then 7.3 was 32 characters and anything newer is currently 64, but I'm hoping to be able to check the lengths from my application before creating a table/sequence/index, etc.. The names have to be generated from the application and as such by allowing a dynamic means to search for them I wont need to "hard code" it.. > On Tuesday 02 September 2003 17:55, Chris Bowlby wrote: > > Hi All, > > > > I've noticed that in the pg_type system table, there is a data type > > called "name", would that represent the definition of the table name > > space, including the max length a talbe name space could be? If so where > > would I find the same definition for the max name space for a sequence, > > or index... > > All names are the same length. This is 64 characters, but I _think_ it can be > changed with a recompile. -- Chris Bowlby <excalibur@hub.org> Hub.Org Networking Services
В списке pgsql-general по дате отправления: