Re: REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE) - Mailing list pgsql-general

On Wed, Jul 18, 2007 at 03:10:30PM +0200, Nico Sabbi wrote:
> Hi,
> as the subjects reads I searched in the docs a way to instruct postgres
> to create new sequences when copying tables containing serial columns,
> but the resulting  serial fields in the new tables reference the
> original sequence.

That's the right behavior.  You should be using

    pg_get_serial_sequence('your_table','your_column')

to get the sequence name anyhow. :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate