Re: Fastest way to import only ONE column into a table? (COPY doesn't work)

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Fastest way to import only ONE column into a table? (COPY doesn't work)
Date: 2007-08-16 05:21:29
Message-ID: 1187241689.310082.153210@g4g2000hsf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Aug 15, 11:46 pm, phoenix(dot)ki(dot)(dot)(dot)(at)gmail(dot)com ("Phoenix Kiula") wrote:
> Appreciate any tips, because it would
> be nasty to have to do this with millions of UPDATE statements!

- Create an interim table
- COPY the data into it
- Do an UPDATE ... FROM ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-16 05:21:43 Re: Deadlocks caused by a foreign key constraint
Previous Message Decibel! 2007-08-16 04:47:07 Re: Interpreting statistics collector output