| From: | "Schlaffer, Sharon" <Sharon(dot)Schlaffer(at)nrl(dot)navy(dot)mil> |
|---|---|
| To: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | insert vs. copy in pgAdmin |
| Date: | 2020-08-27 15:59:10 |
| Message-ID: | 9801F54B-E5E6-4C0B-BDC6-0FA24BA3558E@nrl.navy.mil |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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(dot)schlaffer(at)nrl(dot)navy(dot)mil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Schlaffer, Sharon | 2020-08-27 16:07:16 | insert vs. copy in pgAdmin |
| Previous Message | Wells Oliver | 2020-08-26 17:51:59 | Re: Odd pg dump error: cache lookup failure |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Schlaffer, Sharon | 2020-08-27 16:07:16 | insert vs. copy in pgAdmin |
| Previous Message | marcelo mendoza | 2020-08-20 15:54:15 | Re: Change collate postgresql |