Daily Tag 08/15/2012

• How to export table data to file / csv – PostgreSQL

  "psql -p 5433 -U dba dbname -c “COPY (select url from urltable where scoreid=1 limit 25000) TO STDOUT WITH CSV HEADER;” > /home/yongmo/data25000.csv"

  tags: psql csv COPY

Posted from Diigo. The rest of my favorite links are here.