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/