Re: Executing sql script - Mailing list pgsql-novice

From Joe Erickson
Subject Re: Executing sql script
Date
Msg-id E850FBD66355494C9DEB0E62363EB68F016572A5@dtvemail.datavantage.com
Whole thread Raw
In response to Executing sql script  ("Loftis, Charles E" <charles.loftis@eds.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Executing sql script
Next
From: Chris McCormick
Date:
Subject: problem with pg_restore