Re: Copy from a SELECT

That's exactly what I don't want to do.

I've got *very* limited HDD space for the amount of information I need to
copy out.  The place to where the CSV file is would be output is NTFS and
from the Postgres documentation, it states that I should not put the table
oid files there and link in order to free up space in the default drive.

I've tried using \o to stream the output to a file on the NTFS area, but the
machine ran out of memory (memory = 2G).

I was looking for a work around to copy out the section of data I wanted to
a temporary table and then copy that table out .....



-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Christoph Haller
Sent: 27 February 2003 12:45
To: pgsql-sql@postgresql.org
Cc: val@webtribe.net
Subject: Re: [SQL] Copy from a SELECT


>
> I know that the COPY command requires that you work with plain
> tables.
>
> Is there any other way at all of export only part of a table
>
What about
CREATE [ possibly TEMPORARY ]TABLE table_name AS <your-query>
and then COPY ...

Regards, Christoph



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)