kiwistag
asked on
PostgreSQL Import from database dump, issues with \.
For a database hosted elsewhere we have asked for a dump to use locally with GIS.
The file we have from the dump has the following in it and fails on the import via SQL query.
The error that comes up is:
Invalid command \.. Try \? for help
What am I missing in regards to this, there are multiple large entries with the above just being a short one.
The file we have from the dump has the following in it and fails on the import via SQL query.
COPY catch_methods (name) FROM stdin;
Set Line
Set net
Other
\.
The error that comes up is:
Invalid command \.. Try \? for help
What am I missing in regards to this, there are multiple large entries with the above just being a short one.
are you putting ";" at the end of each line?
ASKER
No, it's not present in the DB dump. That and the EOL would normally be after \. otherwise.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.