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 <robjsarg...@gmail.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.
