On 10/9/19 2:20 PM, PASCAL CROZET wrote:
> 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.
What is the actual command?
This is being done inside a plpgsql function, correct?
If inside a function what is the function code?
My guess is you need to use the CSV format to COPY:
https://www.postgresql.org/docs/11/sql-copy.html
>
> 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 - *<http://www.qualis-consulting.com>Qualis Consulting
> <http://www.qualis-consulting.com/>
>
> •www.qualis-consulting.com <http://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
>
--
Adrian Klaver
adrian.klaver@aklaver.com