Re: Copy from a SELECT

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Cc: val(at)webtribe(dot)net
Subject: Re: Copy from a SELECT
Date: 2003-02-27 12:44:44
Message-ID: 3E5E083C.AA3C60CB@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-02-27 14:41:53 Re: pgsql problem
Previous Message Christoph Haller 2003-02-27 10:13:13 Re: how can i drop a <unnamed> constraint