Database creation script

From: Dani Castaños <danitao(dot)mailists(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Database creation script
Date: 2007-08-22 11:33:10
Message-ID: 46CC1EF6.5030608@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all!

I'm building a database creation script, and i want to modularize it.
Now, I'm trying something like:

/*
- Customer creation script
- Version : 1.0.0
*/

\set ON_ERROR_STOP 1
\set AUTOCOMMIT off

BEGIN;

\i languages_and_countries.sql
\i app_1.sql
\i app_2.sql
[...]

END;

What do you think about this way of doing?
Which is the best option to do it?

Thanks in advance!

Dani Castaños

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2007-08-22 11:36:58 Re: raw data into table process
Previous Message Russell Smith 2007-08-22 11:23:09 Re: raw data into table process