Re: [GENERAL] Load a csv to remote postgresql database
| От | Pavel Stehule |
|---|---|
| Тема | Re: [GENERAL] Load a csv to remote postgresql database |
| Дата | |
| Msg-id | CAFj8pRBSHAkUVOYhRYKTFOSyxMCrrqevv5xFZu0jSMhG4zB4+Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Load a csv to remote postgresql database (priyanka raghav <priyankarag@gmail.com>) |
| Список | pgsql-general |
Hi
2017-03-02 7:01 GMT+01:00 priyanka raghav <priyankarag@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: