From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Вадим Самохин <samokhinvadim(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: copy file from a client app to remote postgres isntance |
Date: | 2022-11-07 18:05:07 |
Message-ID: | 8faa81f6-cce4-f009-c035-d8e0e15e4760@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/7/22 10:51, Вадим Самохин wrote:
> Well, actually, just ordinary 3 tier architecture. Simple UI connected
> via restful API with backend written in php, which copies some data in
> a remote database, that's pretty much it.
>
> пн, 7 нояб. 2022 г. в 20:30, Rob Sargent <robjsargent(at)gmail(dot)com>:
>
> On 11/7/22 09:57, Вадим Самохин wrote:
>> Hi all,
>> I have an application that must copy a local file in csv format
>> to a postgres table on a remote host. The closest solution is
>> this one (https://stackoverflow.com/a/9327519/618020
>> <http://stackoverflow.com/a/9327519/618020>). It boils down to
>> specifying a \copy meta-command in a psql command:
>> |psql -U %s -p %s -d %s -f - <<EOT\n here hoes a \copy
>> meta-command \nEOT\n ||and executing it. B|ut it's quite an unnatural way to write
>> database code. Has anything changed in the last ten years? Or, is
>> there a better wayto copy file contents in a remote database?
> There are bulk copy routines available. What is your architecture?
>
We generally "bottom post" in this group.
Most things I find on the web suggest send the csv file to server and
run COPY there. Some show iterating over the csv, but critical to get
csv off the client.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-11-07 18:08:47 | Re: Segmentation Fault PG 14 |
Previous Message | Вадим Самохин | 2022-11-07 17:51:18 | Re: copy file from a client app to remote postgres isntance |