PostgreSQL pg_dump syntax error in Ubuntu

Question

In ubuntu 16.04 when i want to run pg_dump it doesn't work i got this error syntax error. What is wrong ?

postgres=# pg_dump db_name > db_name1.sql
postgres-#
postgres-# ;
ERROR:  syntax error at or near "pg_dump"
LINE 1: pg_dump db_name > db_name1.sql
        ^
postgres=#

Yasen · Accepted Answer · 2019-07-27 11:52:08Z

6

pg_dump is not an SQL command.

It is a stand-alone utility, so you cannot run it from SQL query. Follow the link for more information.

For your case: type \q<Enter> to quit from SQL-client and repeat your command again using shell prompt. Remember you should use your SQL-credentials. I.e.:

$ pg_dump -U <postgres_user_name> db_name > db_name1.sql`

answered Jul 27, 2019 at 11:52

Yasen

4,5841 gold badge21 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL pg_dump syntax error in Ubuntu

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related