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@postgresql.org)