PostgreSQL Tutorial 5 -- Creating the DB in Postgresql and Switching between DBs
A. Creating Database in Postgresql B. Swithcing between DBs
Posts
PostgreSQL Tutorial 10 -- Taking Table backup in postgresql
Below are the commands to take a table backup in postgresql. A. Taking Table backup with Data. CREATE TABLE contact_backup AS TABLE contacts; B . Taking Table backup without Data. CREATE TABLE new_table AS TABLE existing_table WITH NO DATA;