Thread: copy cmd err

Helo

After running below command am getting error
had run this command before but now am not able to run it

any suggestion  ?

Server Ver :     psql (PostgreSQL) 8.1.11
OS Platform :  Red Hat Enterprise Linux Server release 5.3 (Tikanga)

COPY (SELECT * from function_name (2, 0, 'yyyy-mm-dd','yyyy-mm-dd')) TO
STDOUT


ERROR:  syntax error at or near "(" at character 6
LINE 1: COPY (SELECT * from function_name (2, 0, '2011-08-29','2011...

Thanx
--=20
....=E2=98=BA=C4=B1=C4=B1llll=C4=B1=C4=B1ll=C4=B1=C4=B1 =E2=9C=89 j!=E2=84=
=93=E2=84=AF=C3=B1 =E2=9C=89 l=C4=B1llll=C4=B1=C4=B1ll=E2=98=BA....

Jivendra <soberdude.jivendra@gmail.com> writes:
> Server Ver :     psql (PostgreSQL) 8.1.11
> OS Platform :  Red Hat Enterprise Linux Server release 5.3 (Tikanga)

> COPY (SELECT * from function_name (2, 0, 'yyyy-mm-dd','yyyy-mm-dd')) TO
> STDOUT

That COPY syntax doesn't exist in PG 8.1 --- the option to have a
parenthesized query as the source was added in 8.2.

Even within the RHEL5 world, 8.1.11 is mighty obsolete.  Red Hat is
currently shipping 8.1.23, or you can get 8.4.x in the postgresql84
package set, or you could use Devrim's packages if you don't feel
a need to be all-Red-Hat.

            regards, tom lane