From: | "Joe Erickson" <jerickson(at)datavantagecorp(dot)com> |
---|---|
To: | "Frank Bax" <fbax(at)sympatico(dot)ca>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Executing sql script |
Date: | 2004-06-03 20:58:35 |
Message-ID: | E850FBD66355494C9DEB0E62363EB68F016572A5@dtvemail.datavantage.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | joseph speigle | 2004-06-04 03:40:43 | Re: Cannot insert a duplicate key into unique index |
Previous Message | Frank Bax | 2004-06-03 20:31:34 | Re: Executing sql script |