From: Valerie Goodman <val@webtribe.net>
To: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Cc: val@webtribe.net
Subject: Re: Copy from a SELECT
Date: Thu, 27 Feb 2003 18:28:25 -0000
Message-ID: <NFBBILEJLCBGFCLICKKMMEMKCJAA.val@webtribe.net> (raw)
In-Reply-To: <3E5E083C.AA3C60CB@rodos.fzk.de>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: val@webtribe.net, ch@rodos.fzk.de
Subject: Re: Copy from a SELECT
In-Reply-To: <NFBBILEJLCBGFCLICKKMMEMKCJAA.val@webtribe.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox