psql invalid command \N while restore sql

by

Postgres uses \N as substitute symbol for NULL value. But all psql commands start with a backslash \ symbol. You can get these messages, when a copy statement fails, but the loading of dump continues. This message is a false alarm. You have to search all lines prior to this error if you want to see the real reason why COPY statement failed.

Is possible to switch psql to “stop on first error” mode and to find error:

psql -v ON_ERROR_STOP=1

More Related Contents:

  1. Select rows which are not present in other table
  2. Optimize GROUP BY query to retrieve latest row per user
  3. How to implement a many-to-many relationship in PostgreSQL?
  4. Aggregate columns with additional (distinct) filters
  5. Check if value exists in Postgres array
  6. How to use ANY instead of IN in a WHERE clause?
  7. Is there a shortcut for SELECT * FROM?
  8. sql statement error: “column .. does not exist”
  9. What is the difference between single quotes and double quotes in PostgreSQL?
  10. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  11. sql ORDER BY multiple values in specific order?
  12. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  13. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  14. Best way to count rows by arbitrary time intervals
  15. Sorting null values after all others, except special
  16. Reference alias in WHERE clause
  17. NOT NULL constraint over a set of columns
  18. ERROR: functions in index expression must be marked IMMUTABLE in Postgres
  19. Why postgres returns unordered data in select query, after updation of row?
  20. postgresql – sql – count of `true` values
  21. Continuing a transaction after primary key violation error
  22. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  23. PostgreSQL where all in array
  24. PostgreSQL – fetch the rows which have the Max value for a column in each GROUP BY group
  25. Conditional SQL count
  26. Redundant data in update statements
  27. Parallel unnest() and sort order in PostgreSQL
  28. Postgresql query between date ranges
  29. How in H2DB get sql dump like in MySql?
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment