=========================================================
GATHERING ALL CREATE TABLE STATEMENTS IN POSTGRES DATABASE
=======================================================
1)SELECT any one table, right click and click on BACKUP
2)In FILE OPTIONS TAB, Give any filename by selecting the path
3)select format as PLAIN
4)In DUMP OPTIONS #1 TAB, select ONLY SCHEMA in TYPE OF OBJECTS
5)In DUMP OPTIONS #2 TAB, select Verbose Messages in TYPE OF OBJECTS(This is default option , so you don't hav to do any)
6)In OBJECTS TAB, Select all the tables you want.
7)Click on Backup Button
That's it, The output file does consists of all the tables with CREATE STATEMETNS you Want.
GATHERING ALL CREATE TABLE STATEMENTS IN POSTGRES DATABASE
=======================================================
1)SELECT any one table, right click and click on BACKUP
2)In FILE OPTIONS TAB, Give any filename by selecting the path
3)select format as PLAIN
4)In DUMP OPTIONS #1 TAB, select ONLY SCHEMA in TYPE OF OBJECTS
5)In DUMP OPTIONS #2 TAB, select Verbose Messages in TYPE OF OBJECTS(This is default option , so you don't hav to do any)
6)In OBJECTS TAB, Select all the tables you want.
7)Click on Backup Button
That's it, The output file does consists of all the tables with CREATE STATEMETNS you Want.
