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@hotmail.com
> <mailto:hiddenemail@hotmail.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@hotmail.com looks like a correct email to me.
Maybe if you show what the data is in the table?
>
> *What I need is:*
>
> "","","hiddenemail@hotmail.com
> <mailto:hiddenemail@hotmail.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.klaver@aklaver.com