Postgres Pro
Downloads
Home   >   mailing lists

Re: Command to take only schema backup - Mailing list pgsql-admin

From Harshad Adalkonda
Subject Re: Command to take only schema backup
Date
Msg-id CANnQH_gh=RWTGHhHcgEG1LSMSXL7Y5r131n1+RP0gAbBEsAn5w@mail.gmail.com
Whole thread Raw
In response to Command to take only schema backup  (<shyamkant.dhamke@wipro.com>)
List pgsql-admin
Tree view


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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Logfile purge
Next
From: Harshad Adalkonda
Date:
Subject: Re: Logfile purge