On Tue, 09 May 2006 10:58:07 -0400 Ryan Suarez <[EMAIL PROTECTED]> wrote:
> Greetings, > > I am running postgres 7.4.7 on debian sarge. > > I need to run an SQL query and store the results in a file. The > format needs to be comma separated values (CSV), so I can import this > later in Excel. > > Any ideas on how to accomplish this? > > much appreciated, > Ryan > > > ---------------------------(end of > broadcast)--------------------------- TIP 6: explain analyze is your > friend Ryan, Two tips. First: psql -U <PGSQL USER> -o <OUPUT FILE NAME> --pset format=unaligned --pset fieldsep=',' -c '<SQL COMMAND HERE>' -d <DATABASE NAME HERE> I think that will give you the output you were after assuming you're scripting psql and that you replace the values in <> with appropriate values. The syntax is slightly different from the psql command line. Second: man psql is your friend. John Purser ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
