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

Поиск
Список
Период
Сортировка
От PFC
Тема Re: [SQL] input from a external text file......!
Дата
Msg-id op.s58x60oqcigqcu@apollo13
обсуждение исходный текст
Ответ на input from a external text file......!  ("AKHILESH GUPTA" <akhilesh.davim@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "AKHILESH GUPTA"
Дата:
Сообщение: input from a external text file......!
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: in Pl/PgSQL, do commit every 5000 records