Re: [GENERAL] Length of field names.

1998-07-13 Thread Bruce Momjian
> Yeah I guess I didn't explain that very well. Suppose you did > > \d test > > you'd get > > Field | Type | Length > -- > blah | text | var > number | int2 | 2 > code | char() | 15 > > [hand-made table :)] > > now what is was -badly- tryin

Re: [GENERAL] Length of field names.

1998-07-13 Thread Stuart Rison
>> So my guess is that with the original name, malignant_pathologies_invasive >> and the primary key created by it (normally >> malignant_pathologies_invasive_pkey) end up having the same name because of >> the cut-off? >> >> Does this seem right? If so, what is the max length of field names and

Re: [GENERAL] Length of field names.

1998-07-13 Thread Bruce Momjian
> So my guess is that with the original name, malignant_pathologies_invasive > and the primary key created by it (normally > malignant_pathologies_invasive_pkey) end up having the same name because of > the cut-off? > > Does this seem right? If so, what is the max length of field names and can >