Page 1 of 1

can you retrieve data type and length from PostgreSQL?

Posted: Sun Dec 05, 2004 8:53 pm
by myleow
I know you can retrieve column names using pg_fieldname. Has anyone been able to retrieve the data type associated to that column and the data length contrain of that column?

It would make much better error checking if that is possible.

Thank you in advance.

Regards
Mian

Posted: Sun Dec 05, 2004 9:02 pm
by kettle_drum
pg_meta_data()