insert vs. copy in pgAdmin - Mailing list pgsql-novice

From Schlaffer, Sharon
Subject insert vs. copy in pgAdmin
Date
Msg-id 9801F54B-E5E6-4C0B-BDC6-0FA24BA3558E@nrl.navy.mil
Whole thread Raw
Responses Re: insert vs. copy in pgAdmin
List pgsql-novice

Hello all,

 

When I use the import (csv) into a table feature, it makes a copy. This is not working for our database folks (they need to auto-populate a date/time field and for whatever reason, cannot do this if I “copy” the csv into the db).

Is there a way to import and stipulate “insert” instead (using pgAdmin, that is).

 

Thanks,

Sharon

 

======================================================

Sharon Schlaffer

sharon.schlaffer@nrl.navy.mil 

 

pgsql-novice by date:

Previous
From: marcelo mendoza
Date:
Subject: Re: Change collate postgresql
Next
From: psql-contact@citecs.de
Date:
Subject: can't create table on new db/schema/user