Peter Harvey <[EMAIL PROTECTED]> writes:
> Is this information availible somewhere in the catalog tables?
Yes, in the atttypmod column of pg_attribute.
I'd recommend looking at psql's \d commands (describe.c), or at
pg_dump, to see the approved way to retrieve catalog info. Those
are kept up to
Hi;
I am reverse engineering a PostgreSQL database by querying catalog
tables. I have run into a problem where I can not determine the exact
info used in i.e. the CREATE TABLE statement. For example; how to
determine the exact precision/length and scale used in a NUMERIC(p,s)
column def.
Looking
