Postgresql tips

Start to postgresql :  sudo -u postgres psql postgres

List all databases : 

• \list or \l: list all databases
• \dt: list all tables in the current database

Type \q and then press ENTER to quit psql
Connect to database : \connect database_name
Drop all tables from a database:  drop schema public cascade;

PostGIS , PostgreGIS