From: Daniel CAUNE <d.caune@free.fr>
To: aklaver@comcast.net
To: pgsql-sql@postgresql.org
Subject: Re: Executing plpgsql scripts using psql, is that possible?
Date: Mon, 16 Jan 2006 22:10:34 -0500
Message-ID: <0IT70020VVHQZ391@VL-MO-MR003.ip.videotron.ca> (raw)
In-Reply-To: <200601161835.48794.aklaver@comcast.net>
> If you want to use plpgsql it will need to be within a function. In your
> reply
> you mention creating user-defined functions as part of the set up
> procedure.
> It would not be weird to include the static data function as part of that
> procedure and then call it to load the data. I see no reason to destroy
> the
> function after use. If that is not the route you want to take you may want
> to
> look at the following for information on using COPY to load data from a
> file
> into a table-
> www.postgresql.org/docs/8.1/interactive/sql-copy.html
>
Yes, COPY may be an interesting option too.
Thanks!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: d.caune@free.fr, aklaver@comcast.net
Subject: Re: Executing plpgsql scripts using psql, is that possible?
In-Reply-To: <0IT70020VVHQZ391@VL-MO-MR003.ip.videotron.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox