Postgres Pro
Downloads
Home   >   mailing lists

Thread: Command to take only schema backup

Command to take only schema backup

From
Date:

Hi,

 

Please let me know the command/option to take the backup of schema using PGadmin.

 

Regards

Shyamkant

Re: Command to take only schema backup

From
Harshad Adalkonda
Date:


On Thu, Dec 18, 2014 at 11:08 AM, <shyamkant.dhamke@wipro.com> wrote:

Hi,

 

Please let me know the command/option to take the backup of schema using PGadmin.

 

Regards

Shyamkant


Hi Shyamkant,

In pgAdmin schema backup option is disabled for custom, tar, directory format

so you need to select plain text format to take schema backup.

This backup only takes schema dump no data will be there.

Example:

Right click on Database select Backup In file option Format as Plain & in dump option 1 check only schema and click on Backup.

---
Thanks & Regards,
Harshad Adalkonda
Database Administrator