Thomas Kellerer <spam_eater@gmx.net> writes:
> Belka Lambda wrote on 14.03.2010 01:24:
>> 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'
Relying on adsrc is a very bad idea. I'd suggest
pg_catalog.pg_get_expr(adbin, adrelid)
which is what pg_dump uses.
regards, tom lane
