Обсуждение: psql copy script

Поиск
Список
Период
Сортировка

psql copy script

От
Дата:

Hi Alvaro

Thanks for the help but it does not work.

when I execute it than I get:
[test/data] su - postgres -c "psql logdb -c 'copy test from \'/data/log/bla\''"
Unmatched '.

If I correct the error than I get the following:

[test/data] su - postgres -c "psql logdb -c 'copy test from \'/data/log/bla'\'"
psql: warning: extra command-line argument "copy test from \/data/log/bla\" ignored
psql: FATAL:  role "-c" does not exist

Any idea why?
thx and regards
Aniko

Re: psql copy script

От
Yantao Shi
Дата:
Don't you have to use a "\" in front of copy like : \copy?

I use \copy command all the time, never have any problems with it.

Yantao Shi

Aniko.Badzong@swisscom.com wrote:

> Hi Alvaro
>
> Thanks for the help but it does not work.
>
> when I execute it than I get:
> [test/data] su - postgres -c "psql logdb -c 'copy test from
> \'/data/log/bla\''"
> Unmatched '.
>
> If I correct the error than I get the following:
>
> [test/data] su - postgres -c "psql logdb -c 'copy test from
> \'/data/log/bla'\'"
> psql: warning: extra command-line argument "copy test from
> \/data/log/bla\" ignored
> psql: FATAL:  role "-c" does not exist
>
> Any idea why?
> thx and regards
> Aniko
>
>