| From: | "archiver" <archiver(at)db(dot)geocrawler(dot)com> |
|---|---|
| To: | <pgsql-sql(at)hub(dot)org> |
| Subject: | Simple Question?? |
| Date: | 1999-02-27 22:50:40 |
| Message-ID: | 03ba01be62a3$9a00fd60$0b8c5aa5@timnt.weather.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)perdue(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Natalino Picone | 1999-02-28 00:35:34 | how to make radius become XTRAdius :) - Important Radius Patch |
| Previous Message | Ingrith Andrea Correa Vargas | 1999-02-27 21:35:23 | CREATE TABLE - DEFAULT |