Skip site navigation (1) Skip section navigation (2)

\copy and serial type

From: Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: \copy and serial type
Date: 2002-04-15 09:42:06
Message-ID: 0B87317EA62BD211A02A00A0C9DFB7EC9B5EB2@hermes.bordeaux.cemagref.fr (view raw or flat)
Thread:
Lists: pgsql-novice
I use to enter data in my db with \copy large text files (exports from
MS-Excel).

Is there a mean to auto update  the primary key (as serial) or do I have to
calculate it each time with a function ?

Regards

___________________________________________
Jacques Massé                                                  
Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01



Responses

pgsql-novice by date

Next:From: Andrew McMillanDate: 2002-04-15 09:55:15
Subject: Re: \copy and serial type
Previous:From: Pierre-Alexis PaquinDate: 2002-04-15 08:07:07
Subject: Postgresql starts but nothing 's happened

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group