Re: changing the sequence for a table

Cedric BRINER wrote:
>
> the idea is to drop the ``old_test'' table. But before doing this,
 > I'd like to alter the table ``test'' to use the sequence
 > ``test_id_seq'' instead of ``test_new_seq_id''?

ALTER TABLE new_table ALTER COLUMN my_column DROP DEFAULT;
ALTER TABLE new_table ALTER COLUMN my_column SET DEFAULT
(nextval('old_seq'));
DROP TABLE old_table;

Or something along those lines. See "ALTER TABLE" in the manuals for
details.
--
   Richard Huxton
   Archonet Ltd