[GENERAL] Load a csv to remote postgresql database - Mailing list pgsql-general

From priyanka raghav
Subject [GENERAL] Load a csv to remote postgresql database
Date
Msg-id CAG1EzyRaj9Xk5C-Ad9u7uC01c9n1DnYUX9QivrN=sqUW9uZSvA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Load a csv to remote postgresql database  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: [GENERAL] Load a csv to remote postgresql database  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Understanding pg_last_xlog_receive_location
Next
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] Load a csv to remote postgresql database