Batch Scripting of DB Objects to Separate Files

From: "Mike Fahrenkrog" <mikef(at)travelpost(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Batch Scripting of DB Objects to Separate Files
Date: 2005-07-05 22:46:53
Message-ID: 20050705224554.249425287E@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2005-07-06 09:29:35 libpqxx on windows
Previous Message jose fuenmayor 2005-07-05 18:44:00 Fwd: problems with pgadmin 3