Batch Scripting of DB Objects to Separate Files - Mailing list pgsql-admin

From Mike Fahrenkrog
Subject Batch Scripting of DB Objects to Separate Files
Date
Msg-id 20050705224554.249425287E@svr1.postgresql.org
Whole thread Raw
List pgsql-admin

Hi,

Could someone please advise as to the most efficient way to script database objects (preferably all objects, but particularly functions) to separate files with a single command? Is there a PostgreSQL command or Win32 client tool that can do this? The export metadata tool in EMS PostgreSQL Manager seems to only allow the generation of a single script. I would like to have a separate file for each object, so that I can easily add the objects to source control. We have well over a thousand objects, so I would need to generate these files with a single command, script or batch file.

Thanks,
--Mike

pgsql-admin by date:

Previous
From: jose fuenmayor
Date:
Subject: problems with pgadmin 3
Next
From: "sandhya"
Date:
Subject: libpqxx on windows