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)

cat foo | psql bar

or

pgsql>\i /somedir/foo


--Bryan

On Thu, 2004-06-03 at 12:23, Loftis, Charles E wrote:

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

At 03:23 PM 6/3/04, Loftis, Charles E wrote:

If your file is script.sql, then:
psql < script.sql



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

At 03:45 PM 6/3/04, Joe Erickson wrote:

Is there any guarantee of sequence with either of these?


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Again, I am an idiot. At the time I wrote that, I was thinking of Sybase. PostgreSQL can not do this.

However, in a good shell you can get something like this to work. For instance:

foreach file (example*)
psql $file
end

Shells will put them through in alpha order.

BTW, I use tcsh.


-----Original Message-----
From: pgsql-novice-owner (AT) postgresql (DOT) org
[mailtogsql-novice-owner (AT) postgresql (DOT) org]On Behalf Of Frank Bax
Sent: Thursday, June 03, 2004 4:32 PM
To: pgsql-novice (AT) postgresql (DOT) org
Subject: Re: [NOVICE] Executing sql script


At 03:45 PM 6/3/04, Joe Erickson wrote:

Is there any guarantee of sequence with either of these?


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly