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
--
....☺ııllllııllıı ✉ j!ℓℯñ ✉ lıllllııll☺....
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