Create extension postgis in psql terminal
Create extension postgis in psql terminal
1 | CREATE EXTENSION postgis;
|
Explore postgresql code snippets and tutorials
Create extension postgis in psql terminal
1 | CREATE EXTENSION postgis;
|
Create database with specific owner in psql
1 | CREATE DATABASE databasename WITH OWNER username ENCODING='utf-8';
|
psql connect to database
1 | \c datbase name;
|
exit psql terminal
1 | \q
|
Backup and restore postgresql database
1 2 3 4 | <h2>backup postgresql</h2>
pg_dump -U user-name -d source_db -f dumpfilename.psql
<h2>restore postgresql</h2>
psql -U user-name -d desintation_db -f dumpfilename.sql
|