Monday, December 5, 2016

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


Post a Comment


© 2011 GIS and Remote Sensing Tools, Tips and more .. ToS | Privacy Policy | Sitemap

About Me