Friday, December 29, 2017
export tables structure using phppgadmin
export tables structure using phppgadmin
this trick is useful - and easy- whether you need to export only your tables structure from your PostgreSQL database you may follow these steps:
1. logon using phppgadmin
2. in left pane click on your databases name and expand it using the + icon, just like in the next image:
3. then, go to "tables" option and you will see all your tables; now, from the central toolbar click on the option "Export"
4.so in the next screen you got, just select the option "structure only", whether you would read the commands only at the bottom option menu click on "show", otherwise click on "Download". Finally click on "Export"
5. You will obtain a file with sql extension, whether you click on it, you will see all needed commands in other to export you tables schema. it would be cool whether we decide the files name (by default is named dump), in fact this would be nice in phpmyadmin too but for now we need to name it manually
Best
