Re: Executing sql script - Mailing list pgsql-novice

From Joe Erickson
Subject Re: Executing sql script
Date
Msg-id E850FBD66355494C9DEB0E62363EB68F029FED90@dtvemail.datavantage.com
Whole thread Raw
In response to Executing sql script  ("Loftis, Charles E" <charles.loftis@eds.com>)
List pgsql-novice
Ahh!!  I'm an idiot.

Put -f before the filenames in the command line:

psql -f example.sql

Sorry.



-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Loftis, Charles E
Sent: Thursday, June 03, 2004 3:24 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Executing sql script


I want to execute the sql stored in a directory on my system.

How do I submit this file, in batch, to pgsql to be executed?



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-novice by date:

Previous
From: Bryan Irvine
Date:
Subject: Re: Executing sql script
Next
From: Frank Bax
Date:
Subject: Re: Executing sql script