Postgres Pro
Downloads
Home   >   mailing lists

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

From Rodrigo De León
Subject Re: Fastest way to import only ONE column into a table? (COPY doesn't work)
Date
Msg-id 1187241689.310082.153210@g4g2000hsf.googlegroups.com
Whole thread Raw
In response to Fastest way to import only ONE column into a table? (COPY doesn't work)  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Fastest way to import only ONE column into a table? (COPY doesn't work)
List pgsql-general
Tree view 
On Aug 15, 11:46 pm, phoenix.ki...@gmail.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 ...

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Fastest way to import only ONE column into a table? (COPY doesn't work)
Next
From: Tom Lane
Date:
Subject: Re: Deadlocks caused by a foreign key constraint