Bruce Momjian <bruce@momjian.us> writes:
> What method will people use to see if a sequence used as a default is
> one that was created by SERIAL, and will be dropped by drop table, or
> manually created? How does that distinction show up in pg_dump?
BTW, it's easy to see if a column has an associated sequence:
pg_get_serial_sequence(). It's going from the sequence to the column
that requires manually looking into pg_depend.
regards, tom lane