Small is beautiful. Free UNIX!!!! :: [pgsql] pgsql export to csv

[pgsql] pgsql export to csv

Posted at 2008/10/31 18:38
Filed under db 이야기

To export PostgreSQL data to csv file using psql interactive terminal.

open terminal
su postgres
psql <db_name>
\f ','
\a
\t
\o outputfile.csv
select ..... (your sql select statement)
\o
\q

Additional notes: If you want a TAB delimited file instead of comma, use \f 'Ctrl-V TAB'. \f sets the field separator. \a echo all. \t tuples(rows) only. \q quit.

크리에이티브 커먼즈 라이센스

이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.

Posted by ⓒ쟁이™

Tag: csv, export, pgsql
Response: 14 Trackbacks , a comment
RSS :: http://funix.net/rss/response/32

Trackback URL : http://funix.net/trackback/32

Trackbacks List

Oxicontine.
Tracked from Oxicontine. 2011/02/20 11:18 Delete
Oxicontine.
Buy levitra.
Tracked from Buy levitra. 2011/02/21 08:34 Delete
Compare cialis viagra levitra. Cialis viagra levitra. Buy levitra. Cheap levitra. Cialis versus levitra.
Oxicontine.
Tracked from Oxicontine. 2011/02/22 09:30 Delete
Oxicontine.
Levitra.
Tracked from Levitra. 2011/02/23 07:59 Delete
Levitra.
Testosterone.
Tracked from Testosterone. 2011/03/10 09:05 Delete
Testosterone.
Casino 1299681909
Tracked from Casino 1299681909 2011/03/10 16:56 Delete
Casino 1299681909
Levitra.
Tracked from Levitra. 2011/03/11 08:25 Delete
Levitra.
Abilify.
Tracked from Abilify. 2011/03/12 08:22 Delete
Abilify.
Lipitor.
Tracked from Lipitor side effects. 2011/03/14 06:43 Delete
Lipitor. Lipitor side effects.
Abilify.
Tracked from Abilify. 2011/03/15 06:42 Delete
Abilify.
Lipitor.
Tracked from Lipitor. 2011/03/16 08:37 Delete
Lipitor.
Information on side effects of uroxatral.
Tracked from Information on side effects of uroxatral. 2011/03/17 09:30 Delete
Does uroxatral continue being effective. Viagra and uroxatral. Copd and uroxatral. Bph uroxatral.
Lipitor.
Tracked from Lipitor. 2011/03/19 06:36 Delete
Lipitor 20 mg. Generic for lipitor.
Casino 1300581116
Tracked from Casino 1300581116 2011/03/20 09:30 Delete
Casino 1300581116

Comments List

Borse Gucci 2011/12/05 16:18 # M/D Reply Permalink

gente adulta e la donna è il particolare hanno evolvere crescere per essere bambini consapevoli saranno di lunga data g Borse Gucci più probabilmente dovrebbe venire a uno qualcosa di più nuovo e mai probabile che non solo può sembrare notevole quantità su di loro, ma busto impressione significative quantità dai loro personality.fortunately Gucci Outlet delle donne svelamenti come abbastanza dentro l'accusa di bottino gucci e aggiornare i risultati per produrre lo stato dominante di salute dichiarazione Mark Lee come presidente e ceo di Gucci Group e salvaguardato frida accusa Giannini di coppie gucci sposate significa architettura e gli accessori, come valido John Ray per le cinture di Gucci.