Re: PL/pgSQL

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jim Beckstrom <jrbeckstrom(at)sbcglobal(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PL/pgSQL
Date: 2005-12-03 03:48:37
Message-ID: 20051203034837.GA37350@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Dec 02, 2005 at 04:21:12PM -0800, Jim Beckstrom wrote:
> Is there a way to import PL/pgSQL modules that are created outside
> of Postgres into a Postgres database?

Whatever client you're using should allow you to import commands
from a file. For example, if you're using psql you could pipe or
redirect standard input or use the -f option:

some_command | psql
psql < filename
psql -f filename

You can also import a file from the psql prompt:

\i filename

For more information see the psql documentation or the documentation
for whatever client you're using. If that doesn't help then please
be more specific about what you're trying to do.

--
Michael Fuhr

In response to

  • PL/pgSQL at 2005-12-03 00:21:12 from Jim Beckstrom

Browse pgsql-novice by date

  From Date Subject
Next Message Viva Chu 2005-12-03 19:04:26 Install 8.1 on Mac OS 10.4
Previous Message operationsengineer1 2005-12-03 01:37:44 Re: saving a query and reults to a file.