From: | "Schlaffer, Sharon" <Sharon(dot)Schlaffer(at)nrl(dot)navy(dot)mil> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | insert vs. copy in pgAdmin |
Date: | 2020-08-27 16:07:16 |
Message-ID: | 6BF7B8CE-05B1-44DF-A714-01D55AE9402E@nrl.navy.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-novice |
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
======================================================
Sharon Schlaffer
Naval Research Laboratory - Code 8111
Naval Center for Space Technology, Technical Staff
4555 Overlook Ave. SW. Washington, DC 20375-5000
Tel: 202-329-4648 (Mobile); 301-585-6116 (Home)
sharon(dot)schlaffer(at)nrl(dot)navy(dot)mil<mailto:sharon(dot)schlaffer(at)nrl(dot)navy(dot)mil>
& ShoreshNeg1(at)gmail(dot)com<mailto:ShoreshNeg1(at)gmail(dot)com>
From: Sharon Schlaffer <Sharon(dot)Schlaffer(at)nrl(dot)navy(dot)mil>
Date: Thursday, August 27, 2020 at 11:59 AM
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: insert vs. copy in pgAdmin
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(dot)schlaffer(at)nrl(dot)navy(dot)mil
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Tice | 2020-08-27 16:57:54 | Re: Logical Replication - Rep Manager |
Previous Message | Schlaffer, Sharon | 2020-08-27 15:59:10 | insert vs. copy in pgAdmin |
From | Date | Subject | |
---|---|---|---|
Next Message | psql-contact | 2020-08-28 10:32:02 | can't create table on new db/schema/user |
Previous Message | Schlaffer, Sharon | 2020-08-27 15:59:10 | insert vs. copy in pgAdmin |