Skip site navigation (1) Skip section navigation (2)

Re: Executing sql script

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
cat foo | psql bar


pgsql>\i /somedir/foo


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)

In response to

pgsql-novice by date

Next:From: Joe EricksonDate: 2004-06-03 19:45:03
Subject: Re: Executing sql script
Previous:From: Loftis, Charles EDate: 2004-06-03 19:23:37
Subject: Executing sql script

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group