Message-ID: <03ba01be62a3$9a00fd60$0b8c5aa5@timnt.weather.net>
From: "archiver" <archiver@db.geocrawler.com>
To: <pgsql-sql@hub.org>
Subject: Simple Question??
Date: Sat, 27 Feb 1999 16:50:40 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Here's a question that maybe you can answer easily...

If I am using a sequence (seq_a) in table_a

...then "create table_b as select * from table_a"

...does table_b start using that sequence (seq_a), starting at the point
where table_a left off??

I have a 1GB table that I want to optimize by reordering it, and I will want
the new table to use the same sequence to generate the primary key. I will
then drop the original table and rename the table_b to table_a.

Any clues?

Tim Perdue
tim@perdue.net