Re: [GENERAL] generate CSV with Copy+Quotes - Postgres 9.2

2016-09-21 Thread Patrick B
> > >> > > Perhaps you mean you want to quote of all strings? For that you use FORCE > QUOTE. > eg: > COPY (SELECT > name_first > name_last, > email, > company > FROM > clients > ) > TO '/var/lib/pgsql/test1.csv' DELIMITER

Re: [GENERAL] generate CSV with Copy+Quotes - Postgres 9.2

2016-09-21 Thread Melvin Davidson
On Wed, Sep 21, 2016 at 9:33 AM, Adrian Klaver wrote: > On 09/21/2016 02:23 AM, Patrick B wrote: > >> Hi guys, >> >> I'm exporting some data for testing purpose. >> >> COPY (SELECT >> name_first >> name_last, >> email, >> company >> FROM >>

Re: [GENERAL] generate CSV with Copy+Quotes - Postgres 9.2

2016-09-21 Thread Adrian Klaver
On 09/21/2016 02:23 AM, Patrick B wrote: Hi guys, I'm exporting some data for testing purpose. COPY (SELECT name_first name_last, email, company FROM clients ) TO '/var/lib/pgsql/test1.csv' DELIMITER ',' csv HEADER QUOT

[GENERAL] generate CSV with Copy+Quotes - Postgres 9.2

2016-09-21 Thread Patrick B
Hi guys, I'm exporting some data for testing purpose. COPY (SELECT > name_first > name_last, > email, > company > FROM > clients > ) > TO '/var/lib/pgsql/test1.csv' DELIMITER ',' csv HEADER QUOTE '"'; cat /var/lib/pgsql/test1.csv "","",hiddenem...@hotm