Re: How do I 'include' a stored procedure in a SQL script file

Поиск
Список
Период
Сортировка
От Serge Fonville
Тема Re: How do I 'include' a stored procedure in a SQL script file
Дата
Msg-id 680cbe0e0901070441w6a160458qdfefbd314ad7a5c3@mail.gmail.com
обсуждение исходный текст
Ответ на How do I 'include' a stored procedure in a SQL script file  ("Donna Rudd" <donna@therudds.co.uk>)
Список pgsql-general
An .sql file is just a list of sql you can just as well enter when running psql.
If you had the psql prompt open, what would you type to execute the commands in an .sql file, limited to 'true' sql and not psql specific commands

If you know that you know which lines to add to the .sql file

Hope this helps

Regards,

Serge fonville

On Wed, Jan 7, 2009 at 12:41 PM, Donna Rudd <donna@therudds.co.uk> wrote:
Hi,
All I want to do is 'include' a stored procedure (contained in another
script file) into my main PostgreSQL database creation script file so that
it can get defined/declared before I define my triggers to call it. It seems
such a simple thing but I don't seem to be able to find any examples or
documentation. Please help!


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: "Donna Rudd"
Дата:
Сообщение: How do I 'include' a stored procedure in a SQL script file
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How do I 'include' a stored procedure in a SQL script file