Обсуждение: Command to take only schema backup

Поиск
Список
Период
Сортировка

Command to take only schema backup

От
Дата:

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

От
Harshad Adalkonda
Дата:


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