| From: | "Daniele Medri" <madrid(at)linux(dot)it> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ...copy hack |
| Date: | 2000-03-31 10:34:39 |
| Message-ID: | 000c01bf9afd$034c5200$0200a8c0@casa.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-03-31 11:41:10 | Function tables from my book |
| Previous Message | Hiroshi Inoue | 2000-03-31 10:05:49 | RE: slow join on postgresql6.5 |