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