Re: [SQL] input from a external text file......!

2006-03-11 Thread PFC
inside psql, type : \i filename On Sat, 11 Mar 2006 11:29:20 +0100, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: 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 t

Re: [SQL] input from a external text file......!

2006-03-11 Thread Andreas Kretschmer
AKHILESH GUPTA <[EMAIL PROTECTED]> 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

[SQL] input from a external text file......!

2006-03-11 Thread AKHILESH GUPTA
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..