Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id DEDFF475451
	for <pgsql-sql@postgresql.org>; Wed, 24 Jul 2002 03:24:11 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g6O7O7Vk009467;
	Wed, 24 Jul 2002 03:24:07 -0400 (EDT)
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump and sequences 
In-reply-to: <Pine.LNX.4.44.0207231131150.21717-100000@matrix.gatewaynet.com> 
References: <Pine.LNX.4.44.0207231131150.21717-100000@matrix.gatewaynet.com>
Comments: In-reply-to Achilleus Mantzios <achill@matrix.gatewaynet.com>
	message dated "Tue, 23 Jul 2002 11:33:25 +0300"
Date: Wed, 24 Jul 2002 03:24:07 -0400
Message-ID: <9466.1027495447@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200207/369
X-Sequence-Number: 8747

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