Hi
2017-03-02 7:01 GMT+01:00 priyanka raghav <priyankarag@xxxxxxxxx>:
Hi,
I am trying to load a csv file of approx 500mb to remote postgres
database. Earlier when the app server and db server were co-located,
COPY command was working fine but ever since the db server is moved to
a different box, the command is failing. I understand that COPY
command searches the file on database server which it is not able to
find and hence is throwing an error. I cannot use /COPY as it is a
psql command. What options do I have to go about this. I need an
urgent answer to this. Thanks in advance.
The psql COPY is special case for server side COPY.
if you cannot to use a psql \copy, then you have to use a special API for you programming language that can to create a bridge between client and server.
Why you cannot to use psql \copy ?
Regards
Pavel
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
