Re: query column def - Mailing list pgsql-hackers

From Tom Lane
Subject Re: query column def
Date
Msg-id 10214.998421779@sss.pgh.pa.us
Whole thread Raw
In response to query column def  (Peter Harvey <pharvey@codebydesign.com>)
List pgsql-hackers
Peter Harvey <pharvey@codebydesign.com> 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 date pretty faithfully, whereas other interfaces
aren't necessarily.  (Feel free to submit a patch to fix ODBC...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Link to bug webpage
Next
From: Andrew McMillan
Date:
Subject: Re: Link to bug webpage