Re: Table name lengths...

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(at)hub(dot)org>
Hub.Org Networking Services