Home > mailing lists

Schema dump - Mailing list pgsql-general

From	Sonam Sharma
Subject	Schema dump
Date	January 2, 2020 10:15:10
Msg-id	CAM-M3Tmj=caRsGiyD9_uE_9Ks+GZzjoFQii5twC-H650_GkXFA@mail.gmail.com Whole thread Raw
Responses	Re: Schema dump
List	pgsql-general

I took a schema dump using : pg_dump -n schema dbname .

When I restored this , it doesn't contain the constraints and indexes. Can someone please help how to take a dump including all

From: Matthias Apitz
Date: 01 January 2020, 20:39:36
Subject: Re: How to reset a server error '25P02 in_failed_sql_transaction'

From: Tom Lane
Date: 02 January 2020, 16:47:34
Subject: Re: Schema dump