Re: Convert serial column to regular integer - Mailing list pgsql-sql

Anything pre-8.2?

On 5/11/07, Rodrigo De León <rdeleonp@gmail.com> 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;
>