Re: pg_dump and sequences - Mailing list pgsql-sql

From Tom Lane
Subject Re: pg_dump and sequences
Date
Msg-id 9466.1027495447@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and sequences  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: pg_dump and sequences  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
>> It seems that pg_dump -t "tablename" dumps correctly the sequence of a 
>> table's column,when the column is named after "id".

> I meant "when ONLY" the column is named after "id",

Yeah, you're right.  I'm hoping to see a better answer in 7.3, but
right now it's a horrible kluge ...
        regards, tom lane


pgsql-sql by date:

Previous
From: Daryl Herzmann
Date:
Subject: Re: Queries not using Index
Next
From: "Ian Cass"
Date:
Subject: Re: FATAL 1