psql -U postgres -h localhost -p 5432 -f data_dump.sqlpsql -U username -d dbname < filename.sql#To dump a database called mydb into a SQL-script file:
pg_dump mydb > db.sql
#To reload such a script into a (freshly created) database named newdb:
psql -d newdb -f db.sqlpg_dump dbname > outfilepg_restore -U sam -d SamDataBase -1 SamDataBaseBackup.sql# First create DATABASE
sudo su postgres
# enter password
createdb testdb
psql db_name < dump.sql| Code Example |
|---|
| Sql :: sql query to find percentage of null values in a table |
| Sql :: sql get duplicates by composite |
| Sql :: is numeric in sql |
| Sql :: inner join |
| Sql :: SQL COUNT() With HAVING Clause |
| Sql :: sql server split string last |
| Sql :: mysql max |
| Sql :: c# select Mysql |
| Sql :: show table info mysql |
| Sql :: into sql |
| Sql :: move table to a different schema |
| Sql :: truncate oracle |
| Sql :: postgresql linux password |
| Sql :: select users with same username |
| Sql :: sql right join |
| Sql :: sql string function update replace |
| Sql :: mysql with |
| Sql :: get duplicate entry sql |
| Sql :: sql inserted |
| Sql :: oracle list primary key |
| Sql :: select case when oracle |
| Sql :: change schema in sql server |
| Sql :: postgresql remove duplicate rows 2 columns |
| Sql :: sql tabelle erstellen |
| Sql :: sql datum formatieren |
| Sql :: on update current_timestamp jpa |
| Sql :: sql to linq |
| Sql :: Mysql Selected All Duplicate Rows |
| Sql :: Create the connection pool mysql2 |
| Sql :: to show sp in sql server |