Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: Initializat...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 3040 of 3323
Post > Topic >>

Re: Initialization on server start-up

by fbax@[EMAIL PROTECTED] (Frank Bax) Mar 15, 2008 at 11:55 AM

Alex du Plessis wrote:
> Is there a way to initialize a field in a table in a specific database 
> on server startup?


Simple; just add something like this to a server startup script:

psql -c 'update table set field=value where ...' database user

or

echo 'update table set field=value where ...' | psql database user

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 4 Posts in Topic:
Initialization on server start-up
alexdup01@[EMAIL PROTECTE  2008-03-15 10:02:54 
Re: Initialization on server start-up
terminale@[EMAIL PROTECTE  2008-03-15 13:04:46 
Re: Initialization on server start-up
rmcconne@[EMAIL PROTECTED  2008-03-15 11:10:12 
Re: Initialization on server start-up
fbax@[EMAIL PROTECTED] (  2008-03-15 11:55:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 4:44:38 CST 2008.