> 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!