On Wed, Dec 27, 2006 at 14:05:30 +0100, Enrico <[EMAIL PROTECTED]> wrote: > Is there any way to make a dump from a query? > > For example if my query is: > > select field1,field2 from table > > Does it exist a shell command like pg_dump --QUERY myquery -f myfile?
In 8.2 you can use a query with the COPY command. Depending on what you are really doing, that might be a solution for you. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
