Thread: SQL on startup

I have some sql that creates some operators which I want to be made
available to every connection. Can I run this SQL when postmaster
starts? Is there a way to execute it as the db root user so that the
operators will be available to everyone that connects?


   Nathan Heagy



^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   Front Logic   .   Vividworks   .   Cow Comics   .   Thirty-Nine Days

Nathan Heagy writes:

> I have some sql that creates some operators which I want to be made
> available to every connection. Can I run this SQL when postmaster
> starts? Is there a way to execute it as the db root user so that the
> operators will be available to everyone that connects?

Once you have created the operators they are there persistently.  They do
not get dropped when the server is shut down.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/