Re: Load a csv to remote postgresql database

Hi

2017-03-02 7:01 GMT+01:00 priyanka raghav <priyankarag(at)gmail(dot)com>:

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>