Postgres Pro
Downloads
Home   >   mailing lists

Re: Executing SQL Script - Mailing list pgsql-general

From Richard Huxton
Subject Re: Executing SQL Script
Date
Msg-id 42B115AA.8080304@archonet.com
Whole thread Raw
In response to Executing SQL Script  (Jamie Deppeler <jamie@doitonce.net.au>)
List pgsql-general
Tree view 
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.

psql -f my_script_file -U username mydbname
or
psql -U username mydbname < my_script_file

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: [HACKERS] INHERITS and planning
Next
From: Nico Callewaert
Date:
Subject: Re: Installation on latest version of Suse Linux