Re: Executing plpgsql scripts using psql, is that possible?

Поиск
Список
Период
Сортировка
От Daniel CAUNE
Тема Re: Executing plpgsql scripts using psql, is that possible?
Дата
Msg-id 0IT70020VVHQZ391@VL-MO-MR003.ip.videotron.ca
обсуждение исходный текст
Ответ на Re: Executing plpgsql scripts using psql, is that possible?  (Adrian Klaver <aklaver@comcast.net>)
Ответы Characters that needs escape characters when inserting to database  ("Christian Paul B. Cosinas" <cpc@cybees.com>)
Список 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 по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Executing plpgsql scripts using psql, is that possible?
Следующее
От: "Christian Paul B. Cosinas"
Дата:
Сообщение: Characters that needs escape characters when inserting to database