integer column to serial "type"

From: Linos <info(at)linos(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: integer column to serial "type"
Date: 2012-10-25 15:32:39
Message-ID: 50895B97.4070008@linos.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
there is some way to get and old integer primary key column to show the "type"
serial at table description?

I had a table like this:

CREATE TABLE test
(
test_id integer NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (test_id),
);

that i would like to see as:

CREATE TABLE test
(
test_id serial NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (test_id),
);

i have tried with:

CREATE SEQUENCE test_test_id_seq;
ALTER TABLE test ALTER COLUMN test_id SET DEFAULT
nextval('test_test_id_seq'::regclass);
ALTER SEQUENCE test_test_id_seq OWNED BY test.test_id;

and now i have this table:

CREATE TABLE test
(
test_id integer NOT NULL DEFAULT nextval('test_test_id_seq'::regclass),
CONSTRAINT test_pkey PRIMARY KEY (test_id),
);

i know this works the same as serial but do i have some way to get this table to
show me test_id column as "serial" type without have to recreate the table and
restore original rows?

Regards,
Miguel Angel.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-10-25 15:39:51 Re: integer column to serial "type"
Previous Message Martin Gainty 2012-10-25 14:18:04 Re: migrate from PostgreSQL to Oracle