Re: Initialization on server start-up - Mailing list pgsql-novice

From Frank Bax
Subject Re: Initialization on server start-up
Date
Msg-id 47DBF15B.3040906@sympatico.ca
Whole thread Raw
In response to Initialization on server start-up  (Alex du Plessis <alexdup01@telkomsa.net>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Bob McConnell
Date:
Subject: Re: Initialization on server start-up
Next
From: Weiwei Guo
Date:
Subject: What is a password for?