Re: Mass Import/Generate PKs
От | Franco Bruno Borghesi |
---|---|
Тема | Re: Mass Import/Generate PKs |
Дата | |
Msg-id | 1099775607.71652.5.camel@taz.oficina обсуждение исходный текст |
Ответ на | Re: Mass Import/Generate PKs (Hunter Hillegas <lists@lastonepicked.com>) |
Ответы |
Re: Mass Import/Generate PKs
|
Список | pgsql-general |
the simplest way to do it seems to be adding a SERIAL column to your table, and then adding a primary key constraint:
1)insert data into table
2)ALTER TABLE <table> ADD id SERIAL;
3)ALTER TABLE <table> ADD CONSTRAINT <table>_pk PRIMARY KEY (id);
you can check the docs for the SERIAL type: http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL
On Sat, 2004-11-06 at 17:29, Hunter Hillegas wrote:
1)insert data into table
2)ALTER TABLE <table> ADD id SERIAL;
3)ALTER TABLE <table> ADD CONSTRAINT <table>_pk PRIMARY KEY (id);
you can check the docs for the SERIAL type: http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL
On Sat, 2004-11-06 at 17:29, Hunter Hillegas wrote:
That sounds nice and easy... So, I would do something like 'ALTER TABLE' to generate the PK column? What would be the best way to populate it? Is there an area of doco I should be looking at? Thanks, Hunter > From: Peter Eisentraut <peter_e@gmx.net> > Date: Sat, 6 Nov 2004 21:21:25 +0100 > To: Hunter Hillegas <lists@lastonepicked.com>, PostgreSQL > <pgsql-general@postgresql.org> > Subject: Re: [GENERAL] Mass Import/Generate PKs > > Hunter Hillegas wrote: >> I have a CSV file with 400,000 lines of email mailing list >> information that I need to migrate to a new PostgreSQL database. >> >> Each line has all the info I need except a PK (I usually use an int4 >> column for a PK). > > You could import the file into PostgreSQL and add a primary key column > later. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Вложения
В списке pgsql-general по дате отправления: