Обсуждение: how to Export ALL plpgsql functions/triggers to file

Поиск
Список
Период
Сортировка

how to Export ALL plpgsql functions/triggers to file

От
"Naoko Reeves"
Дата:

Hi,

Could you tell me how to Export ALL plpgsql functions/triggers to file?

 

Thank you

Re: how to Export ALL plpgsql functions/triggers to file

От
"Albe Laurenz"
Дата:
Naoko Reeves wrote:
> Could you tell me how to Export ALL plpgsql
> functions/triggers to file?

I'd do it as follows:

- Perform a pg_dump of the database object definitions:
  pg_dump -F c -s -f database.dmp database

- Create a listing, delete everything except triggers and functions:
  pg_restore -l database.dmp | awk '/[0-9]*; [0-9]* [0-9]* (FUNCTION|TRIGGER)/ { print }' > database.list

- Create an SQL script with only these objects:
  pg_restore -L database.list -f database.sql database.dmp

The only shortcoming is that it does not make a distinction
between PL/pgSQL and other functions; you could filter again with awk
or something if you need that.

Yours,
Laurenz Albe