SEO

#1 (**permalink**) 04-10-2008, 05:45 AM

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

#2 (**permalink**) 04-10-2008, 05:45 AM

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
>
>

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

psql copy script