On Monday 12 January 2009 3:14:56 am DonnaR wrote:
> Currently I'm using PGAdmin to create everything, but I need to create a
> script file to create the schemas and the tables to ultimately run outside
> of PGAdmin. Since I have triggers, I need to 'load in' the (long)
> stored/triggered procedure
Currently I'm using PGAdmin to create everything, but I need to create a
script file to create the schemas and the tables to ultimately run outside
of PGAdmin. Since I have triggers, I need to 'load in' the (long)
stored/triggered procedures during this process (ie 'call or 'include'
another file
In response to Donna Rudd :
> 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 se
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 thi
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
