Re: Executing sql script

Just put it on the command line after psql:

psql example.sql

psql will take the file and run each line to the server.

If the server is not on your computer, you will need to specify the hostname to the computer and a username to log into the server with:

psql -h server.postgres.com -U dba example.sql

To send multiple files, just list them all:

psql example1.sql example2.sql example3.sql

or

psql example*

Run psql --help for more options.

-----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)