INSERT... WHERE

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: INSERT... WHERE
Date: 2013-01-14 02:00:39
Message-ID: CAGYyBgj1o7xawrR+=gHFSoejti3QZ-qtOEs6+DY=BedW=vwGXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2013-01-14 02:05:01 special procedure required when running pg_basebackup from a standby?
Previous Message Robert James 2013-01-14 01:58:08 Bulk INSERT with individual failure