Thread: Re: Re: Run scripts

Re: Re: Run scripts

From
Guy Fraser
Date:
Lee Harr wrote:
>
> On 24 Aug 2001 05:43:37 -0700, Christoph <christoph..lange@web.de> wrote:
> > Working with oracle I used the command
> > @/home/lange/textfile.sql
> > to run scripts. Does anyone happen to know how this works with postgres?
> >
>
> In psql, you could use:
>
> \i /home/lange/textfile.sql
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

From the command line, you can do this :

psql -f /home/lange/textfile.sql database

--
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.