Skip site navigation (1) Skip section navigation (2)

Re: COPY (query) TO file

From: "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY (query) TO file
Date: 2006-06-02 14:01:18
Message-ID: 18278.24.91.171.78.1149256878.squirrel@mail.mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> Mark Woodward wrote:
>> Tom had posted a question about file compression with copy. I thought
>> about it, and I want to through this out and see if anyone things it is
>> a
>> good idea.
>>
>> Currently, the COPY command only copies a table, what if it could
>> operate
>> with a query, as:
>>
>> COPY (select * from mytable where foo='bar') as BAR TO stdout
>>
>> I have no idea if it is doable, but I can see uses for replication
>
> I doubt it be really usefull (apart from maybe saving some work
> coding a client app) but did you actually test it with
>
> create table as select ...; followed by a copy of that table
> if it really is faster then just the usual select & fetch?

Why "create table?"

The idea is that you would have one or more redundent databases and use
the COPY TO/FROM to keep them up to date.

In response to

Responses

pgsql-hackers by date

Next:From: Tino WildenhainDate: 2006-06-02 14:04:45
Subject: Re: COPY (query) TO file
Previous:From: Andrew DunstanDate: 2006-06-02 13:56:07
Subject: Re: COPY (query) TO file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group