sábado, 14 de febrero de 2015

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 database's 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 file's 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

No hay comentarios:

Publicar un comentario