PDA

View Full Version : How do I save the output of a PostgreSQL query?


Arundhati Bakshi
10-08-2007, 08:48 PM
I am logging into a remote server to do my work. I need to know how to save the output of a psql query into a file on my local hard drive. Thanks in advance.
I log into the remote server and then I need to find out how to get the output of the query into a text file. From within the postgres prompt, I am not sure how to do this.

fdj1
10-09-2007, 04:53 AM
Cant you save it as a .txt file?
or do you mean save the query?