I'm trying to export some tables to another Postgres server. When I used to use MySQL, I could do this by right clicking the desired table/database in the sidebar, choosing "Export Database as SQL", and choosing my target server as the output.
With two Postgres servers though, when I try to run the export, I get a syntax error:
ERROR: syntax error at or near "USE" LINE 1: USE "public" ^
Exporting to a SQL file first and then running that file in the new server works, but is less convenient, would be nice if this issue could be fixed.