Re: Install scripts?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Charl Gerber <cpger(at)xs4all(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Install scripts?
Date: 2005-02-25 18:09:39
Message-ID: 200502251909.41099.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Charl Gerber wrote:
> DROP DATABASE db_name IF EXISTS (<--- is there something similar in
> Postgre? Like the CREATE OR REPLACE FUNCTION)

No, you just go ahead and ignore the error.

> CREATE DATABASE db_name;
>
> USE db_name;

\connect db_name

> SOURCE users.sql;

\i users.sql

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexis Vasquez 2005-02-25 18:22:55 unsuscribe
Previous Message Tom Lane 2005-02-25 18:07:12 Re: Install scripts?