Bruce Momjian <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster