Re: [SQL] input from a external text file......! - Mailing list pgsql-general

From PFC
Subject Re: [SQL] input from a external text file......!
Date
Msg-id op.s58x60oqcigqcu@apollo13
Whole thread Raw
In response to input from a external text file......!  ("AKHILESH GUPTA" <akhilesh.davim@gmail.com>)
List pgsql-general
inside psql, type :

\i filename



On Sat, 11 Mar 2006 11:29:20 +0100, AKHILESH GUPTA
<akhilesh.davim@gmail.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.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"



pgsql-general by date:

Previous
From: "AKHILESH GUPTA"
Date:
Subject: input from a external text file......!
Next
From: "Florian G. Pflug"
Date:
Subject: Re: in Pl/PgSQL, do commit every 5000 records