Adrianna Pinska <[EMAIL PROTECTED]> writes:
> More specifically, I've been looking for a way to persuade postgresql
> to output the create script for a single object - without much
> success. It seems that pg_dump can output a dump of the entire
> database schema or a dump of a single table, but n
On Wed, Mar 23, 2005 at 14:10:30 +0200,
Adrianna Pinska <[EMAIL PROTECTED]> wrote:
>
> More specifically, I've been looking for a way to persuade postgresql
> to output the create script for a single object - without much
> success. It seems that pg_dump can output a dump of the entire
> databa
On Wed, 23 Mar 2005 07:32:08 -0500, Sean Davis <[EMAIL PROTECTED]> wrote:
> You can look at the system catalogs. In particular, look at:
>
> http://www.postgresql.org/docs/current/static/catalogs.html
> http://www.postgresql.org/docs/current/static/catalog-pg-proc.html
Thanks - the info you get
You can look at the system catalogs. In particular, look at:
http://www.postgresql.org/docs/current/static/catalogs.html
http://www.postgresql.org/docs/current/static/catalog-pg-proc.html
You can do something like
select proname,prosrc from pg_proc;
as an example. You could use one of the procedu
Hello,
I'm working on a project which uses postgresql (7.4.x), and a lot of
the project code is in functions, views, etc. in a postgresql
database. I would like to create an automated process for extracting
all this code to individual text files (which can be managed through a
version control sys
