X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 40EB4475E84 for ; Thu, 27 Feb 2003 13:59:43 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 01386-01 for ; Thu, 27 Feb 2003 13:59:30 -0500 (EST) Received: from blueyonder.co.uk (pcow034o.blueyonder.co.uk [195.188.53.122]) by postgresql.org (Postfix) with ESMTP id 3F852475F1B for ; Thu, 27 Feb 2003 13:29:06 -0500 (EST) Received: from val ([80.193.4.64]) by blueyonder.co.uk with Microsoft SMTPSVC(5.5.1877.757.75); Thu, 27 Feb 2003 18:31:08 +0000 From: "Valerie Goodman" To: "Christoph Haller" , Cc: Subject: Re: Copy from a SELECT Date: Thu, 27 Feb 2003 18:28:25 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 In-Reply-To: <3E5E083C.AA3C60CB@rodos.fzk.de> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/597 X-Sequence-Number: 11995 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 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)