Re: query column def

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