Horton

Re: [SQL] Running a file

Brett W. McCoy <bmccoy@chapelperilous.net>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: Thomas SMETS <tsmets@altern.org>
Cc: psql Admin <pgsql-admin@postgresql.org>, psql sql <pgsql-sql@postgresql.org>
Date: 2000-12-24T17:24:21Z
Lists: pgsql-sql 
On Sun, 24 Dec 2000, Thomas SMETS wrote:

> I'm runnin postgres 7.?? (Last RPM package available from the site).
>
> I want to create a few DB creation scripts so I can "publish" that
> afterwards.
> On Oracle there's a such possibility but I haven't seen anything
> comaprable in the docs ...
> I however think I'm missing one of the very first possibility of
> "pgsql".
> Could someone point me were I could find some more infos on that matter
> ?

Are you talking about writing external scripts and importing them into
Postgres in a manner similar to the @ function in SQL*Plus?  In psql, you
can use \i to import scripts to do that.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Reading is to the mind what exercise is to the body.