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:44:10
Message-ID: 4769C8EA.3000005@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

Responses

pgsql-admin by date

Next:From: Phillip SmithDate: 2007-12-20 02:04:59
Subject: Re: including variables in copy command
Previous:From: DineshDate: 2007-12-20 01:31:04
Subject: including variables in copy command

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