Re: Executing plpgsql scripts using psql, is that possible? - Mailing list pgsql-sql

From Daniel CAUNE
Subject Re: Executing plpgsql scripts using psql, is that possible?
Date
Msg-id 0IT70020VVHQZ391@VL-MO-MR003.ip.videotron.ca
Whole thread Raw
In response to Re: Executing plpgsql scripts using psql, is that possible?  (Adrian Klaver <aklaver@comcast.net>)
Responses Characters that needs escape characters when inserting to database  ("Christian Paul B. Cosinas" <cpc@cybees.com>)
List pgsql-sql
> 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!



pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: Executing plpgsql scripts using psql, is that possible?
Next
From: "Christian Paul B. Cosinas"
Date:
Subject: Characters that needs escape characters when inserting to database