Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy from a SELECT - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Copy from a SELECT
Date
Msg-id 3E5E083C.AA3C60CB@rodos.fzk.de
Whole thread Raw
In response to Copy from a SELECT  (val@webtribe.net)
Responses Re: Copy from a SELECT  ("Valerie Goodman" <val@webtribe.net>)
List pgsql-sql
Tree view 
>
> 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

pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: how can i drop a constraint
Next
From: Christoph Haller
Date:
Subject: Re: pgsql problem