At times we need to export the data from database to a comma seperated file(CSV) through psql command terminal, here is a quick and easy way to do it
open terminal
[root@vishy vishy]#su postgres
bash-3.2$psql <db_name>
prdideas=# \f ‘,’
Field separator is “,”.
prdideas=# \a
Output format is unaligned.
prdideas=# \t
Showing only tuples.
prdideas=# \o ~/results.csv
prdideas=#select <SQL STATEMENT>
prdideas=#\o
prdideas=#\q
Filed under: OpenSource
Trackback Uri
I want to blog regularly but so far I have failed in my endevours to take blogging as regular affair. After going through this presentation I have found new motivation to try again, Merlin has hit the bulls eye in this presentation of his, no fancy stuff pretty simple and obvious thing but than you need to figure out what is obvious sometimes. Enjoy the presentation and keep rhyming
Find you obsession. Everyday explain it to one person you respect. Edit everything, skip shortucts, and try not to be a dick.Get Better
Filed under: General,non-techanical
Trackback Uri