I keep getting the error “relation [TABLE] does not exist”

by

Each element has to be quoted individually:

select "ID" 
from "Schema"."table1";

More details about quoted identifiers are in the manual

More Related Contents:

  1. PostgreSQL “Column does not exist” but it actually does
  2. sql statement error: “column .. does not exist”
  3. Error: Column does not exist
  4. Postgresql Column Not Found, But Shows in Describe
  5. PostgreSQL column ‘foo’ does not exist
  6. How to return result of a SELECT inside a function in PostgreSQL?
  7. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  8. Possible to perform cross-database queries with PostgreSQL?
  9. Reset auto increment counter in postgres
  10. Optimize query with OFFSET on large table
  11. GROUP BY and aggregate sequential numeric values
  12. Safely rename tables using serial primary key columns
  13. How to concatenate columns in a Postgres SELECT?
  14. How to use (install) dblink in PostgreSQL?
  15. get JOIN table as array of results with PostgreSQL/NodeJS
  16. How can I send email from PostgreSQL trigger?
  17. PostgreSQL multi INSERT…RETURNING with multiple columns
  18. Postgres manually alter sequence
  19. What’s the proper index for querying structures in arrays in Postgres jsonb?
  20. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  21. Postgres sql insert query syntax error from phpPgAdmin
  22. Aggregating (x,y) coordinate point clouds in PostgreSQL
  23. Does Postgres support nested or autonomous transactions?
  24. PostgreSQL delete with inner join
  25. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  26. Update a column of a table with a column of another table in PostgreSQL
  27. Check if NULL exists in Postgres array
  28. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  29. Temporal database design, with a twist (live vs draft rows)
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment