Re: postgresql field size information
| From: | Cornelia Boenigk | Date: | Thu, 27 May 2004 18:28:25 +0000 |
| Subject: | Re: postgresql field size information | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34574@lists.php.net to get a copy of this message | ||
Hi
Try
select attname, format_type(atttypid, atttypmod),
col_description(attrelid, attnum) from pg_attribute, pg_class c where
c.oid = attrelid
and attnum > 0 and c.relname = 'tablename' ;
Regards
Conni
--
Datenbanklösungen + PostgreSQL + Webdesign
http://www.cornelia-boenigk.de | http://www.pgsql.info
http://www.dpunkt.de/buch/3-89864-175-9.html