| From: | "Joe Erickson" <jerickson(at)datavantagecorp(dot)com> |
|---|---|
| To: | "Loftis, Charles E" <charles(dot)loftis(at)eds(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Executing sql script |
| Date: | 2004-06-03 19:47:39 |
| Message-ID: | E850FBD66355494C9DEB0E62363EB68F029FED90@dtvemail.datavantage.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Loftis, Charles E
Sent: Thursday, June 03, 2004 3:24 PM
To: pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)org)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryan Irvine | 2004-06-03 20:23:49 | Re: INSERT or COPY: Which one? |
| Previous Message | Frank Bax | 2004-06-03 19:45:10 | Re: Executing sql script |