Postgres Pro
Downloads
Home   >   mailing lists

INSERT... WHERE - Mailing list pgsql-general

From Robert James
Subject INSERT... WHERE
Date
Msg-id CAGYyBgj1o7xawrR+=gHFSoejti3QZ-qtOEs6+DY=BedW=vwGXA@mail.gmail.com
Whole thread Raw
Responses Re: INSERT... WHERE  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: INSERT... WHERE  (Ian Lawrence Barwick <barwick@gmail.com>)
Re: INSERT... WHERE  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-general
Tree view 
I have a lot of VALUES I want to INSERT.  But only a subset of them -
only those that meet a JOIN criteria involving another table.

I could INSERT them into a temp table, and then do a SELECT INTO.  But
do I need to do that?  Is there any way to do a INSERT... VALUES ...
WHERE...

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Bulk INSERT with individual failure
Next
From: Lonni J Friedman
Date:
Subject: special procedure required when running pg_basebackup from a standby?