I have completed a uni assignment creating a data mart via command line using PostgreSQL. Now I need to provide an export file for my hand-in.
I tried to use the following commands in the terminal:
pg_dump -U kirstincathlin -F p -d airbnb > airbnb.sql
ERROR: syntax error at or near “pg_dump”
LINE 1: pg_dump -U kirstincathlin -F p -d airbnb > airbnb.sql
THEN
airbnb=# pg_dumpall > dump.sql;
ERROR: syntax error at or near “pg_dumpall”
Kirst is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.