Re: Executing SQL Script

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Executing SQL Script
Date: 2005-06-16 09:55:51
Message-ID: 4f8779a221ab6e13d2c69f1b55efdf41@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jun 15, 2005, at 9:47 PM, Jamie Deppeler wrote:

> This is a simple question what is the best way to execute a SQL
> script, this script will create schemas and tables for a database i
> created.
>

Nearly all clients or interfaces provide a means to execute arbitrary
SQL. You can do so in PgAdminIII, for example. For an out-of-the-box
solution, you can use psql -f. See documentation here:

http://www.postgresql.org/docs/8.0/static/app-psql.html

Sean

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2005-06-16 09:59:49 Re: Autovacuum in the backend
Previous Message Sean Davis 2005-06-16 09:51:16 Re: pg_dumpall