'How to convert a sql dump file into postgresql database without syntax error?

I'm using a PostgreSQL database on production(Digital ocean). I created a dump file of my database and then download that dump file to my local computer. Now I want to create a database of PostgreSQL by using that dump file. My production PostgreSQL version is 13.5 and on development, its version is 13.5

Whenever I try to create a database from that dump file I got various syntax errors but have no clue why?

e.g

COPY public.auth_group (id, name) FROM stdin;
\.

Error

ERROR:  syntax error at or near "\"
LINE 1785: \.
           ^
SQL state: 42601
Character: 46562

Even MySQL and SQLite do not create a database from that file. Syntax error.e

database postgresql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to convert a sql dump file into postgresql database without syntax error?

Sources

Related Questions