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

From: PFC <lists(at)peufeu(dot)com>
To: "AKHILESH GUPTA" <akhilesh(dot)davim(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] input from a external text file......!
Date: 2006-03-11 11:29:14
Message-ID: op.s58x60oqcigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


inside psql, type :

\i filename

On Sat, 11 Mar 2006 11:29:20 +0100, AKHILESH GUPTA
<akhilesh(dot)davim(at)gmail(dot)com> 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 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(dot)davim(at)gmail(dot)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"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2006-03-11 13:40:10 Re: in Pl/PgSQL, do commit every 5000 records
Previous Message Andreas Kretschmer 2006-03-11 10:33:18 Re: input from a external text file......!

Browse pgsql-sql by date

  From Date Subject
Next Message Jesper K. Pedersen 2006-03-11 16:31:33 Merging rows into one result?
Previous Message Andreas Kretschmer 2006-03-11 10:33:18 Re: input from a external text file......!