Re: ...copy hack - Mailing list pgsql-hackers

From Daniele Medri
Subject Re: ...copy hack
Date
Msg-id 000c01bf9afd$034c5200$0200a8c0@casa.it
Whole thread Raw
List pgsql-hackers
sometimes ago...
i posted a question.
"How to store data in postgresql, query data.. and produce accessible data
for gnuplot'in a graph"

This is the first hack:
1) select data into temp-table from table where x.. y.. z..
2) copy temp-table into file.txt using delimiters ' '

This way create some problems...
a) to update temp-table with latest data.. i must drop this table before.

Why don't do directly "copy" on view?
This could be very usefull... than "copy" only on table (or temp-table).. a
"copy" on a view-data.

Let's me know about...

Daniele Medri



pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: BIT datatype
Next
From: Bruce Momjian
Date:
Subject: Function tables from my book