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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Christoph Haller Sent: 27 February 2003 12:45 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
