Cannot import .sql to PostgreSQL. Syntax error

Question

Probably a very simple error but I cannot work it out for the life of me. Basically, I am loading a .sql dump into a postgres DB using

psql testdb< C:\Users\Callum\Desktop\backup.sql

However, I get the error:

ERROR:  syntax error at or near "`"
LINE 1: DROP TABLE IF EXISTS `table1`;
                             ^
ERROR:  syntax error at or near "`"
LINE 1: CREATE TABLE `table2` (
                     ^
ERROR:  syntax error at or near "`"
LINE 1: LOCK TABLES `table3` WRITE;

I have been trying to work this out for days and could not find any anwsers online.

Thanks

apoteet · Accepted Answer · 2018-05-03 21:33:46Z

3

Are you importing from MySQL? You don't need backticks here, you can take them out.

answered May 3, 2018 at 21:33

apoteet

7946 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Callum Clark Over a year ago

It could potentially be an mySQL database but I was delivered a SchemaSpy report stating that it was a postgresSQL db. I will give mySQL a try in that case.

Collectives™ on Stack Overflow

Cannot import .sql to PostgreSQL. Syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related