Import and Export data

export:

pg_dump -h localhost -p 5432 -U user -d database_name  -f pg_dump.sql

import:

psql -h localhost -d database_name -U user -p 5432 -f pg_dump.sql


Notes:

- the geospatial data : need install postgis in postgres (or use postgis/postgis image instead of postgres image in docker)

- make sure to the destination server have similar users/roles as the source server

Comments

Post a Comment

Popular posts from this blog

PostgreSQL CREATE INDEX Statement

Image
  Summary : in this tutorial, you will learn how to use the PostgreSQL   CREATE INDEX   statement to define a new index for a table. Introduction to PostgreSQL CREATE INDEX statement An index is a separate data structure that enhances the speed of data retrieval from a table, at the cost of additional writes and storage required to maintain it. An index allows you to improve the query performance when using it appropriately, especially on large tables. To create an index on one or more columns of a table, you use the  CREATE INDEX  statement. Here’s the basic syntax of the  CREATE INDEX  statement: CREATE INDEX [ IF NOT EXISTS ] index_name ON table_name(column1, column2, ...); Code language: SQL (Structured Query Language) ( sql ) In this syntax: First, specify the index name after the  CREATE INDEX  clause. Second, use the  IF NOT EXISTS  option to prevent an error if the index already exists. Third, provide the table name t...
Read more

Understanding LIKE vs ILIKE in PostgreSQL

  The ILIKE operator is a PostgreSQL extension that works exactly like the LIKE operator, except that it is case insensitive. This means that it does not matter whether the string and the pattern have the same case or not. For example, the pattern 'A%' matches both 'apple' and 'Apple' when using the ILIKE operator.
Read more