| From: | Gary M <postgres-general(at)mwwm(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Table, Field, ... name lengths |
| Date: | 2003-03-19 19:27:45 |
| Message-ID: | Pine.LNX.4.44.0303191243040.4686-100000@ruby.gem |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am in the process of assisting the move from MSSQL to PostgreSQL; the
PgAdmin tool has been extremely useful.
We have however run into a few glitches along the way...
MSSQL7 limits database, table and field names to 128 characters in length.
Using psql I find that table and field names are truncated at 63
characters; is this a Pg-imposed limit?
It appears that the PgAdmin2 Migration tool limits created names to 32
characters which presents a problem since the (MS) DBA has used some
rather long entity names. Is there a version of the Migration tool that
supports the full (63-character) length names of Pg 7.3.2?
Staff coming from the MS arena are fond of using long-named fields.
Realizing DBs so created would be non-Pg-standard, is there a way to
increase the limit on name length through Pg re-compilation?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-03-19 19:50:29 | Re: Indexing order by desc |
| Previous Message | Richard Huxton | 2003-03-19 19:17:41 | Re: Error loading /usr/lib/postgresql/plpgsql.so |