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)