Re: use fopen iso-8859-1 resource - Mailing list pgsql-general

From ourdiaspora
Subject Re: use fopen iso-8859-1 resource
Date
Msg-id FPQBkGZpsb1CdQX5UIFJTWTaTpYa6spcn_LR3KD6ylvpyWRerxZ9O19SP0zICAwtxta9Wzq5vc1VfKdlWVUXUy8kMaL8OzwbElhBB31WszQ=@protonmail.com
Whole thread Raw
In response to Re: use fopen iso-8859-1 resource  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: use fopen iso-8859-1 resource  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Friday, August 27th, 2021 at 11:10 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

> https://www.php.net/manual/en/pdo.pgsqlcopyfromfile.php
>

"
public PDO::pgsqlCopyFromFile(
    string $table_name,
    string $filename,
"

Sorry but do not understand; the line does not explain what to write in the php file.

So far have written:
"
<?php
    $userfile=file(./
    $dbusertemporary = pg_connect("dbname=cpacweb user=cpaca");
    $usertemporarydata = pg_copy_from (
        resource $dbusertemporary,
        string $userdata,
        array $rows,
        string $delimiter = ',',
        string $null_as = '\\N'
        ): array;
"

The plan is to write an html file for a user to select a csv file to import into a database. The manual suggests that
thefile name is already known (e.g. https://www.php.net/manual/en/function.fgetcsv.php) 

Instead of:
"
...
fopen("test.csv", "r"))
...
"

it would _not_ be possible to write, correct?:
"
...
fopen("", "r"))



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Can we get rid of repeated queries from pg_dump?
Next
From: Tom Lane
Date:
Subject: Re: Can we get rid of repeated queries from pg_dump?