copy file from a client app to remote postgres isntance

From: Вадим Самохин <samokhinvadim(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: copy file from a client app to remote postgres isntance
Date: 2022-11-07 16:57:04
Message-ID: CAGVmuwoKkos2ssA7-MNpsQkxO=0ouOGS9PtqzFViJ2+0SDeXkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 - <<EOT\n here hoes a \copy meta-command \nEOT\n

and executing it. But it's quite an unnatural way to write database
code. Has anything changed in the last ten years? Or, is there a
better way to copy file contents in a remote database?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2022-11-07 17:29:49 Re: copy file from a client app to remote postgres isntance
Previous Message Sascha Zenglein 2022-11-07 16:16:07 AW: AW: Reducing bandwidth usage of database replication