input from a external text file......!
Hi All.........!
I just want to know one thing that is it possible with PGSQL that,
if I want to insert and execute a query from a external text file instead of
giving it at the pgsql prompt?
just like in Oracle the file having query is executed with a '@ filename'
statement at the sql prompt......!
plz help me and mail me @ akhilesh.davim@gmail.com, it's urgent.
thanks in advance.......................!
(i have searched alot, but didn't found anything)
--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)
"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
AKHILESH GUPTA <akhilesh.davim@gmail.com> schrieb:
Hi All.........!
I just want to know one thing that is it possible with PGSQL that,
if I want to insert and execute a query from a external text file instead of
giving it at the pgsql prompt?
in psql, try simple "\i your_file.sql" to execute the commands within
this file.
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�
inside psql, type :
\i filename
On Sat, 11 Mar 2006 11:29:20 +0100, AKHILESH GUPTA
<akhilesh.davim@gmail.com> wrote:
Show quoted text
Hi All.........!
I just want to know one thing that is it possible with PGSQL that,
if I want to insert and execute a query from a external text file
instead of
giving it at the pgsql prompt?
just like in Oracle the file having query is executed with a '@ filename'
statement at the sql prompt......!
plz help me and mail me @ akhilesh.davim@gmail.com, it's urgent.
thanks in advance.......................!
(i have searched alot, but didn't found anything)--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"