Re: Executing sql script

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
[mailto:pgsql-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:
>To send multiple files, just list them all:
>
>psql example1.sql example2.sql example3.sql
>
>or
>
>psql example*

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