clean rebuild process? - Mailing list pgsql-general

From chris markiewicz
Subject clean rebuild process?
Date
Msg-id 007201c09077$c7b1cc40$dbb846c6@cmarkiewicz
Whole thread Raw
In response to Re: Re: PostreSQL SQL for MySQL SQL  (Chuck Esterbrook <echuck@mindspring.com>)
Responses Re: clean rebuild process?
List pgsql-general
hello.

i am trying to develop a relatively clean process for creating/populating a
new database.  i have all of the table creation scripts and am about to
start writing scripts to populate the db with the necessary default data (an
admin user, a guest user, default application info, default preferences, etc
etc etc).  is there any easy way to do this?

my current approach is to write a bunch of insert statements in a text
editor.  i can do this, but it's error prone (or i guess i am).  obviously
if i already have a source db i can do some table copying, but i would like
to make this work for a fresh install on a new machine.

is there a better way?

the limit of my imaginatin is this - some sort of command/utility that
queries a table and generates the insert statements from the results.  then
i wouldn't have to worry about updating my default data scripts everytime
data changes.

i appreciate your help/suggestions.

chris


pgsql-general by date:

Previous
From: Chuck Esterbrook
Date:
Subject: Re: Re: PostreSQL SQL for MySQL SQL
Next
From: Culley Harrelson
Date:
Subject: selecting a random record