Re: dumping query results to a csv

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 separator
Use 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux