Re: Programmatically duplicating a schema

2018-03-12 Thread matt . figg
Thanks Adrian,   Really appreciate the suggestions.   The objective when trying to solve this for the Apartment library itself is to keep it generic (works for any/all database objects - tables, views, stored procedures, 3rd party extension objects, e

Programmatically duplicating a schema

2018-03-12 Thread matt . figg
Hi all, What is a reliable way to programmatically & generically populate an empty schema with all the objects in the public schema as a template? We are using the multi tenancy ruby gem Apartment ( https://github.com/influitive/apartment ), which was recently broken by the changes made to pg_dump