serial column detection
От | Linos |
---|---|
Тема | serial column detection |
Дата | |
Msg-id | 5089865C.5000808@linos.es обсуждение исходный текст |
Ответы |
Re: serial column detection
|
Список | pgadmin-support |
Hi!,how detects PgAdmin when it should show a column as "type" serial? i am trying to replicate in a existing table the conditions to get shown as serial but i don't get it. 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), ); What should i do? Thanks! Regards, Miguel Angel.
В списке pgadmin-support по дате отправления: