Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to take database dump in postgresql

pg_dump dbname > outfile
Comment

psql load dump

psql databasename < data_base_dump
Comment

PREVIOUS NEXT
Code Example
Sql :: Get first name and last name from full name string in SQL 
Sql :: between from sql 
Sql :: como saber si tengo mysql instalado 
Sql :: postgres update multiple columns 
Sql :: PostgreSQL types and C# types 
Sql :: oracle table free space 
Sql :: remove foreign key constraints in postgres 
Sql :: mysql compare timestamp in minutes 
Sql :: database timezone 
Sql :: mysql query with sql to get the next row 
Sql :: select distinct postgres 
Sql :: if column value is null then in mysql 
Sql :: mysql select distinct date from timestamp 
Sql :: sql precent format 
Sql :: role "postgres" does not exist 
Sql :: get the location of where postgres database is stored 
Sql :: mysql set boolean default value 
Sql :: mysql url data type 
Sql :: mysql get date from datetime 
Sql :: call postgres function 
Sql :: sql display max value 
Sql :: mysql show create table 
Sql :: mysql regex exact match 
Sql :: mysql not equal 
Sql :: sql find all different values in column 
Sql :: psql select * from table 
Sql :: add clumn to table postgres 
Sql :: creating sqeuence in oracle database 
Sql :: sqlite select split string 
Sql :: ms sql print more than 1 variable 
ADD CONTENT
Topic
Content
Source link
Name
3+3 =