2011/5/22 Scott Marlowe <scott.marlowe@xxxxxxxxx>: > On Sat, May 21, 2011 at 10:57 PM, jun yang <slickqt@xxxxxxxxx> wrote: >> now all the question: >> 1.how start a procedure or a script after postgresql start. > > Do you need this stored procedure or script to always run at pg > database start? Or every time a client connects to the database? Or > every minute, or every hour or every day? i am just want pg execute the given stored procedure every time after pg sucess start. > >> 2.how to get notify when a table created. >> 3.how to get notify when a database created. > > Set db to log all dll, scrape logs, email timestamp from table or db > creation. Do you need more info other than just that it was created? > well,it may be not what i want, if i can start a procedure after pg start,then i would like to get notify when new object create,of course,i should be subcribe first. now what i interest is the database created, when a new database created,i want to init some schme and table,index in the it. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general