Robby Russell <robby@planetargon.com> writes:
> Ok, so how would I go about getting the sequence name for a SERIAL
> field on any given schema.table?
8.0 will have a function pg_get_serial_sequence to do this for you.
If you can't wait, the secret is to look in pg_depend for the dependency
link from the serial sequence to its column.
regards, tom lane