Sql

Search

postgresql backup and restore globals and data

$ pg_dump -U postgres -h localhost -p 5433 --clean --file=sandbox.sql sandbox
$ pg_dumpall -U postgres -h localhost -p 5433 --clean --globals-only --file=globals.sql

Comment

postgresql backup and restore globals and data

$ psql -U postgres -h localhost -p 5433 < globals.sql
$ psql -U postgres -h localhost -p 5433 < sandbox.sql

Comment

PREVIOUS	NEXT

Code Example
Sql :: remove last characters in mysql
Sql :: SQL Remove Primary Key Constraint - MySQL
Sql :: nth highest salary in sql
Sql :: sqlite copy table to another table
Sql :: update table sql multiple set
Sql :: sql inner join
Sql :: mysql function to remove multiple spaces from the string
Sql :: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row:
Sql :: sql remove check constraint
Sql :: sql server on mac m1
Sql :: how to make case insensitive in sql
Sql :: PostgreSQL: To_Number function
Sql :: delete table in mysql
Sql :: how to find 2nd highest salary in a table
Sql :: sql case statement
Sql :: mysql select case insensitive
Sql :: sql select most frequent value in group
Sql :: mysql last friday of current month
Sql :: mysql on kubernetes
Sql :: sql insert exemplo
Sql :: when matched in sql server
Sql :: mysql update
Sql :: 2 max value in sql
Sql :: convert minutes to hours sql
Sql :: plpgsql coalesce equivalent for empty string
Sql :: unique sql
Sql :: what is truncate in sql
Sql :: how to average max mysql
Sql :: sql cte example
Sql :: check if user defined table type exists in sql server

Search

SQL

postgresql backup and restore globals and data

postgresql backup and restore globals and data

ADD CONTENT