Search
 
SCRIPT & CODE EXAMPLE
 

SQL

backup postgres database

pg_dump -h localhost -U postgres -W -d mydb > mydb.sql 
Comment

How to backup databases using psql

pg_dump -U postgres mydb > mydb.sql
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle simple quote 
Sql :: sort order on two columns sql 
Sql :: install mysql 5.7 ubuntu 20.04 
Sql :: mysql create a user 
Sql :: create table mysql integer NOT null 
Sql :: exec procedure oracle 
Sql :: oracle previous year 
Sql :: oracle select invalid views 
Sql :: select only one row sql 
Sql :: sql right characters 
Sql :: convert columns to rows in sql server 
Sql :: mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client 
Sql :: SQLITE_BUSY: database is locked 
Sql :: identify primary key in oracle table 
Sql :: mysql run script 
Sql :: oracle all dates between two dates 
Sql :: postgresql regex extract a word from string 
Sql :: postgresql remove duplicate rows 2 columns 
Sql :: update table sql multiple set 
Sql :: how to duplicate mysql table 
Sql :: rand mysql 
Sql :: mysql remove database 
Sql :: how to start my sql server on mac 
Sql :: commit transaction sql 
Sql :: oracle get foreign keys on table 
Sql :: sql server update top n records 
Sql :: alter boolean column postgresql 
Sql :: count weekend days between two dates sql 
Sql :: mysql generate create table script 
Sql :: sql select data type of query 
ADD CONTENT
Topic
Content
Source link
Name
9+8 =