Postgres Pro
Downloads
Home   >   mailing lists

Re: Dump all the indexes/constraints/roles - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Dump all the indexes/constraints/roles
Date
Msg-id 717b60b0-5305-3d7c-8fc6-8536d01bf685@aklaver.com
Whole thread Raw
In response to Dump all the indexes/constraints/roles  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view 
On 10/17/2016 08:32 PM, Patrick B wrote:
> Hi guys,
>
> I need to export an entire database to another server, for testing purpose.
>
> Is there any way to export all indexes and constraints ?

pg_dump the_database

> Postgres 9.2
> Patrick


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Dump all the indexes/constraints/roles
Next
From: Raimo Jormakka
Date:
Subject: Collations and codepages