[SQL] save sql result to file

[william lim]

how to save sql result to a text file in database-backup format?
I want to backup a portion of data from my query to files and can do restore 
from them.

Thanks

William

___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
-- 
___
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [SQL] save sql result to file

[Guy Fraser]

Off the top of my head:

psql -c select  into dump_table from old_table  ; database
pg_dump -t dump_table -f dump_table.tmp database
sed -e s/dump_table/table_name/g dump_table.tmp table_name.sql
rm dump_table.tmp

You should now have a file called table_name.sql with the stuff 
required to create a new table called table_name with the data 
from your query.

On Thu, 2004-23-12 at 20:44 -0800, william lim wrote: 
 how to save sql result to a text file in database-backup format?
 I want to backup a portion of data from my query to files and can do restore 
 from them.
 
 Thanks
 
 William
 
 ___
 Sent by ePrompter, the premier email notification software.
 Free download at http://www.ePrompter.com.


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match