Batch Scripting of DB Objects to Separate Files

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

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.

Thanks,
--Mike

Browse pgsql-novice by date

  From Date Subject
Next Message David 2005-07-06 02:58:33 Backups - WAL archiving. problem understanding documentation
Previous Message Jeffrey Melloy 2005-07-05 21:38:21 Re: Ambiguous columns