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(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Christoph Haller
Sent: 27 February 2003 12:45
To: pgsql-sql(at)postgresql(dot)org
Cc: val(at)webtribe(dot)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(at)postgresql(dot)org)