Re: generate CSV with Copy+Quotes - Postgres 9.2

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 QUOTE '"';
>
>
>
> cat /var/lib/pgsql/test1.csv
>
> "","",hiddenemail(at)hotmail(dot)com
> <mailto:hiddenemail(at)hotmail(dot)com>,"",John Wayne
>

In your COPY you have fields and in the CSV file you have five.
Are you looking at the correct file?

>
> See how the email and the company aren't into two "?

Have no idea what you are trying to say.

hiddenemail(at)hotmail(dot)com looks like a correct email to me.

Maybe if you show what the data is in the table?

>
> *What I need is:*
>
> "","","hiddenemail(at)hotmail(dot)com
> <mailto:hiddenemail(at)hotmail(dot)com>","","John Wayne"
>
>
> I thought that by putting QUOTE the COPY would do that?
>
> Is there any way I can put the " into those fields?
>
> Cheers
>
> Patrick
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com