Thread: insert vs. copy in pgAdmin

Apologies for possibly “cross-listing” (there is a reason I subscribed to the list entitled, “novice” ; )

I think I should have directed my pgAdmin question to this list:

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

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