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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Frank Bax
Sent: Thursday, June 03, 2004 4:32 PM
To: pgsql-novice@postgresql.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