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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
