Whoops, should have also mentioned that you want -P format=unaligned like so: psql -P format=unaligned -F ',' snort <<EOF select * from iphdr; EOF On Thu, 25 Aug 2005, Jeff Frost wrote:
David, You're probably looking for something like this from the psql man page: -F separator --field-separator separatorUse separator as the field separator. This is equivalent to\pset fieldsep or \f. I would guess -F "," would do the trick. On Thu, 25 Aug 2005, David Durham wrote:This is kind of a pg-admin newbie question, so apologies in advance. Anyway, I'd like to issue a command that dumps the results of a query to a txt file in comma delimited format. Does PostgreSQL ship with something to do this? I searched the web, but found what appeared to be non-free solutions. Thanks, Dave ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
-- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
