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

Re: ...copy hack

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 (view raw or flat)
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


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-03-31 11:41:10
Subject: Function tables from my book
Previous:From: Hiroshi InoueDate: 2000-03-31 10:05:49
Subject: RE: slow join on postgresql6.5

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