Lists: | pgsql-novice |
---|
From: | "Loftis, Charles E" <charles(dot)loftis(at)eds(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Executing sql script |
Date: | 2004-06-03 19:23:37 |
Message-ID: | 25DC89BACF65D549BA045B806348C65E01AAF65D@ushem201.exse01.exch.eds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
I want to execute the sql stored in a directory on my system.
How do I submit this file, in batch, to pgsql to be executed?
From: | Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com> |
---|---|
To: | "Loftis, Charles E" <charles(dot)loftis(at)eds(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Executing sql script |
Date: | 2004-06-03 19:44:52 |
Message-ID: | 1086291892.12812.1.camel@elvis2.horvitznewspapers.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
cat foo | psql bar
or
pgsql>\i /somedir/foo
--Bryan
On Thu, 2004-06-03 at 12:23, Loftis, Charles E wrote:
> I want to execute the sql stored in a directory on my system.
>
> How do I submit this file, in batch, to pgsql to be executed?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)