Search Postgresql Archives

Re: Pet Peeves?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




You can however pull it from a -Fc backup with pg_restore. Just FYI.

Joshua D. Drake

Or strip it from a pg_dump/pg_dumpall with sed. Or write your own function-dumper based on ideas gleaned from various notes/comments on the web (my approach).

I had not thought of using the -Fc approach but it appears that that would require dumping the whole database then using pg_restore to pull the function definition from the dump.

One other thing that would be nice to have for function-dumping whether in pg_dump or using the -Fc approach would be the ability to dump all functions of a given name instead of having to go one-by-one. It's pretty unusual for identically-named functions to have unrelated purposes.

Cheers,
Steve


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux