Postgres Pro
Downloads
Home   >   mailing lists

plpgsql copy import csv double quotes - Mailing list pgsql-general

From PASCAL CROZET
Subject plpgsql copy import csv double quotes
Date
Msg-id 453a8fd209f4444aacf7214b96c6eaa9@qualis-consulting.com
Whole thread Raw
Responses Re: plpgsql copy import csv double quotes
Re: plpgsql copy import csv double quotes
List pgsql-general
Tree view

Hi, MailingList

 

PG 9.3 under Ubuntu 14.04 (I know, that’s obsolete, but we’re planning to move to pg 10 or more during 2020)

I’ve experience issues with double quotes \34 inside fields, in a csv file.

 

Ex :

"value1","some text","other text with "double quotes" inside","last field"

 

When I import this line in a table, with the exact column number, with the « copy » command in plpgslq, the import fails.

Saying that too many fields are present. 

 

I tried to catch the double quotes and delete then, but that’s hard under AWK or sed

_________________________________

Cordialement, Pascal CROZET

DBA - Qualis Consulting

• www.qualis-consulting.com • 04 78 22 74 90
• Le Bois des Côtes 1 – Bâtiment A
• 300 Route Nationale 6 – 69760 LIMONEST
_________________________________

GRANT and REVOKE trigger on a ddl_command_end event trigger but don't provide any information beyond whether it was a table, schema, function, etc. that was affected. No object IDs or the like are included. How would you find out which table had its ACLs modified?

Also, why do grants and revokes have an object_type of 'TABLE' instead of lower case names like 'table' for all other event types?


Thanks,

Miles Elam

Attachment

pgsql-general by date:

Previous
From: Miles Elam
Date:
Subject: Event Triggers and GRANT/REVOKE
Next
From: Adrian Klaver
Date:
Subject: Re: plpgsql copy import csv double quotes