Re: feature proposal ...

Rod Taylor wrote:
>>the problem is: COPY can write data returned by a SELECT statement to a 
>>file. our idea is to implement precisely that.
>>
>>example:
>>
>>COPY TO file_name USING some_select_statement;
> 
> 
> I have run into plenty of cases where I wanted to dump part of a
> structure and this could be used for that, but I've always found that
> temporary tables were sufficient and equally SQL scriptable
> 
>         CREATE TEMP TABLE tab AS SELECT ...; COPY tab TO file_name;


Hi Rod,

TEMP TABLE are not suitable for my case. Using a temp table would 
essentially mean that we had to store the data 3 times: Original data, 
temp table + dump. Temp tables are only fine for small amounts of data 
but we are talking about too much data here (my smallest export will 
contain 15.000.000 records).
Best regards,
    Hans


-- 
Cybertec Geschwinde & Schönig GmbH
Schöngrabern 134; A-2020 Hollabrunn
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at