Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group