Re: [SQL] Convert serial column to regular integer

[Collin Peters]

Anything pre-8.2?

On 5/11/07, Rodrigo De León <[EMAIL PROTECTED]> wrote:

CREATE TABLE dtab (i SERIAL);

ALTER TABLE dtab ALTER COLUMN i DROP DEFAULT;

ALTER SEQUENCE dtab_i_seq OWNED BY NONE;

DROP SEQUENCE dtab_i_seq;

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq