Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7D3F09F998F for ; Wed, 22 Aug 2007 08:33:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 66010-02 for ; Wed, 22 Aug 2007 08:33:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id E69309F9675 for ; Wed, 22 Aug 2007 08:33:16 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so112852nfh for ; Wed, 22 Aug 2007 04:33:15 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=pzBnvvT6HDyEtpM5JH9gqNT+8GgtWMjdtU4jZfZZ3x4a0O4Dr5ngW7g7jZ2eMyUVkYygYJ1+ZNKvKE7OqexZCNgmGl9YYxr2cnppc+AMOAfAhCeQH1P4tKhv3mywC4vBc3jtANGn2w2E9ScZPwLjxfeVhMMV11usHvj8pv18KVA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=Kn2xwSrCHvAq/HwB568/EjfFEnZ+sOeseKjX7T/tAGGrxWBqZ6AgMam5mxOMNLJGJUciNsMXNR+BwC/3rROI6n52GWu8r2ze33SzsQogj/ZT1bs1khhxv6nofbqvNClZzyxKoDLe/ComYKiI89QpzNdR8rpu4zIoml6vDAIrutE= Received: by 10.78.195.9 with SMTP id s9mr388593huf.1187782394911; Wed, 22 Aug 2007 04:33:14 -0700 (PDT) Received: from ?192.168.10.68? ( [193.238.52.47]) by mx.google.com with ESMTPS id 30sm326322hue.2007.08.22.04.33.12 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 22 Aug 2007 04:33:13 -0700 (PDT) Message-ID: <46CC1EF6.5030608@gmail.com> Date: Wed, 22 Aug 2007 13:33:10 +0200 From: =?ISO-8859-1?Q?Dani_Casta=F1os?= User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Database creation script Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/191 X-Sequence-Number: 29129 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