On Tue, May 09, 2006 at 08:57:57AM -0700, John Purser wrote: > > I am running postgres 7.4.7 on debian sarge. > 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. Third: 7.4.7 is ancient and suffers from a number of data loss bugs. If you need to stick with 7.4 you should at least be running the most current version. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
