Skip site navigation (1) Skip section navigation (2)

including variables in COPY command

From: Dinesh <dbhandary(at)mongonet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: including variables in COPY command
Date: 2007-12-20 01:28:21
Message-ID: 4769C535.2000603@mongonet.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hi ALL,

I am trying to use Copy command to copy data from table to a flat file. 
Here is an example:

copy ( select * from employee where hire_date between begin_date and 
end_date) to '/var/data/text.txt' delimiter ';';

But my problem is the query is not able to read variable begin_date and 
end_date. It works fine when I passed the real value. Has anyone used 
variable within a copy ?  Please let me know.

Thanks,

Dinesh



pgsql-admin by date

Next:From: DineshDate: 2007-12-20 01:31:04
Subject: including variables in copy command
Previous:From: Phillip SmithDate: 2007-12-19 23:42:32
Subject: Re: Dump database more than 1 flat file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group