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