public inbox for [email protected]  

help / color / mirror / Atom feed

insert vs. copy in pgAdmin
3+ messages / 2 participants
[nested] [flat]

* insert vs. copy in pgAdmin
@ 2020-08-27 15:59  Schlaffer, Sharon <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Schlaffer, Sharon @ 2020-08-27 15:59 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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
[email protected]




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* insert vs. copy in pgAdmin
@ 2020-08-27 16:07  Schlaffer, Sharon <[email protected]>
  parent: Schlaffer, Sharon <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Schlaffer, Sharon @ 2020-08-27 16:07 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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)
[email protected]<mailto:[email protected]>
& [email protected]<mailto:[email protected]>


From: Sharon Schlaffer <[email protected]>
Date: Thursday, August 27, 2020 at 11:59 AM
To: "[email protected]" <[email protected]>
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
[email protected]





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: insert vs. copy in pgAdmin
@ 2020-08-28 11:32  Laurenz Albe <[email protected]>
  parent: Schlaffer, Sharon <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Laurenz Albe @ 2020-08-28 11:32 UTC (permalink / raw)
  To: Schlaffer, Sharon <[email protected]>; [email protected] <[email protected]>

On Thu, 2020-08-27 at 15:59 +0000, Schlaffer, Sharon wrote:
> 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).

Try to get a detailed technical description of your DBAs' problems.

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

I don't think so.

But you can COPY to a temporary table and then use

  INSERT INTO ... SELECT ...

to populate the target table from the temporary table.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2020-08-28 11:32 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-27 15:59 insert vs. copy in pgAdmin Schlaffer, Sharon <[email protected]>
2020-08-27 16:07 ` Schlaffer, Sharon <[email protected]>
2020-08-28 11:32 ` Laurenz Albe <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox