| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: input from a external text file......! |
| Date: | 2006-03-11 10:33:18 |
| Message-ID: | 20060311103317.GA11598@KanotixBox |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
AKHILESH GUPTA <akhilesh(dot)davim(at)gmail(dot)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°
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2006-03-11 11:29:14 | Re: [SQL] input from a external text file......! |
| Previous Message | AKHILESH GUPTA | 2006-03-11 10:29:20 | input from a external text file......! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2006-03-11 11:29:14 | Re: [SQL] input from a external text file......! |
| Previous Message | AKHILESH GUPTA | 2006-03-11 10:29:20 | input from a external text file......! |