Belka Lambda wrote on 14.03.2010 01:24:
Hi everyone!
Is there a way to "nicely" determine a default value of a table column? A
function, which could be used, like:
The defaults are store in pg_attrdef, the corresponding column definitions in
pg_attribute.
So you would need to do a join between the two tables, something like:
select c.relname, a.attname, def.adsrc
from pg_attrdef def
join pg_class c on def.adrelid = c.oid
join pg_attribute a on a.attrelid = c.oid and a.attnum = def.adnum
where c.relname = 'the_table_name'
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
