On 12/10/23 10:34, Johnson, Bruce E - (bjohnson) wrote:
>
>> On Dec 10, 2023, at 10:41 AM, Vincent Veyron <vv.lists@wanadoo.fr
>> <mailto:vv.lists@wanadoo.fr>> wrote:
>>
>> External Email
>>
>> On Fri, 8 Dec 2023 10:45:28 -0500
>>
>> Duh! I just realized that what I proposed with system() is a command
>> line approach.
>>
>> As David Johnston mentionned, you can use the SQL COPY command.
>
> One thing to remember with the Perl DBI is that you can use a string
> variable in the $dbh->do() command.
>
> Perl uses 2 different string variable delimiters:
>
> 1) ‘ ‘ , which is exactly what you enter $s= ‘\copy * from foo as
> json’; will send that to the database without the need for escaping
> anything (unless you need to enter an actual ‘ in the command, in which
> case method two is better)
The issue is \copy is not a SQl statement, it is a psql(Postgres command
line client) meta-command. This means it can only be used in psql.
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>
> Institutions do not have opinions, merely customs
>
--
Adrian Klaver
adrian.klaver@aklaver.com