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?