Re: copy file from a client app to remote postgres isntance

2022-11-10 Thread Вадим Самохин
чт, 10 нояб. 2022 г. в 01:32, Peter J. Holzer : > On 2022-11-09 12:57:23 -0600, Ron wrote: > > On 11/9/22 10:17, Peter J. Holzer wrote: > > > On 2022-11-07 14:40:40 -0600, Ron wrote: > > > > On 11/7/22 10:57, Вадим Самохин wrote: > > > > I have an application that must copy a local file in cs

Re: copy file from a client app to remote postgres isntance

2022-11-09 Thread Peter J. Holzer
On 2022-11-09 12:57:23 -0600, Ron wrote: > On 11/9/22 10:17, Peter J. Holzer wrote: > > On 2022-11-07 14:40:40 -0600, Ron wrote: > > > On 11/7/22 10:57, Вадим Самохин wrote: > > > I have an application that must copy a local file in csv format to a > > > postgres table on a remote host. T

Re: copy file from a client app to remote postgres isntance

2022-11-09 Thread Ron
On 11/9/22 10:17, Peter J. Holzer wrote: On 2022-11-07 14:40:40 -0600, Ron wrote: On 11/7/22 10:57, Вадим Самохин wrote: 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.c

Re: copy file from a client app to remote postgres isntance

2022-11-09 Thread Peter J. Holzer
On 2022-11-07 14:40:40 -0600, Ron wrote: > On 11/7/22 10:57, Вадим Самохин wrote: > 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). It boils down

Re: copy file from a client app to remote postgres isntance

2022-11-09 Thread Peter J. Holzer
On 2022-11-07 19:57:04 +0300, Вадим Самохин wrote: > 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). It boils down to specifying a \copy > meta-command in a psql

Re: copy file from a client app to remote postgres isntance

2022-11-07 Thread Ron
On 11/7/22 10: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 ). It boils down to speci

Re: copy file from a client app to remote postgres isntance

2022-11-07 Thread Adrian Klaver
On 11/7/22 8:57 AM, Вадим Самохин 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 ). It boils down to sp

Re: copy file from a client app to remote postgres isntance

2022-11-07 Thread Rob Sargent
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 : On 11/7/22 09:57, Вадим

Re: copy file from a client app to remote postgres isntance

2022-11-07 Thread Вадим Самохин
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 : > On 11/7/22 09:57, Вадим Самохин wrote: > > Hi all, > I have an appli

Re: copy file from a client app to remote postgres isntance

2022-11-07 Thread Rob Sargent
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 ). It boils down to spec

copy file from a client app to remote postgres isntance

2022-11-07 Thread Вадим Самохин
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). It boils down to specifying a \copy meta-command in a psql command: psql -U %s -p %s -d %s -f - <