RadarURL Dev Tips
April 26th, 2012 at 4:22PM

pg_dump: No matching tables were found

Solution :

 pg_dump -U dbUser —inserts  -t ‘“tbTableName”’ dataBaseName  >stor.sql

#pg_dump#postgrsql#table#dump#sql
April 26th, 2012 at 1:05PM

[PostgreSQL] How dump database with inserts ?

pg_dump -U dbUser —inserts  db_Name  > file.sql.dump

#sql#postgrsql#dump#pg_dump
April 24th, 2012 at 4:44PM

[PostgreSQL] How clear (truncate) all tables in database? 

pg_dump --schema-only mydb > mydb.schema.dump 
dropdb mydb 
psql -f mydb.schema.dump mydb

#PostgreSQL#SQL#pg_dump#psql
April 24th, 2012 at 4:35PM

[PostgreSQL] How create clone/copy database ?

su postgres

psql 

CREATE DATABASE mynew_db WITH TEMPLATE myOld_db  OWNER myUser1;

#postgreSQL#SQL#psql#postgres#clone db#copy db