sql statement error: “column .. does not exist”

by

No, the column FK_Numbers_id does not exist, only a column "FK_Numbers_id" exists

Apparently you created the table using double quotes and therefor all column names are now case-sensitive and you have to use double quotes all the time:

select sim.id as idsim, 
       num.id as idnum 
from main_sim sim 
   left join main_number num on ("FK_Numbers_id" = num.id);

To recap what is already documented in the manual:

The column foo and FOO are identical, the columns "foo" and "FOO" are not.

More Related Contents:

  1. PostgreSQL “Column does not exist” but it actually does
  2. Error: Column does not exist
  3. I keep getting the error “relation [TABLE] does not exist”
  4. Postgresql Column Not Found, But Shows in Describe
  5. PostgreSQL column ‘foo’ does not exist
  6. Does PostgreSQL support “accent insensitive” collations?
  7. PostgreSQL DISTINCT ON with different ORDER BY
  8. PostgreSQL: running count of rows for a query ‘by minute’
  9. Split comma separated column data into additional columns
  10. IN vs ANY operator in PostgreSQL
  11. How to delete duplicate entries?
  12. How to include “zero” / “0” results in COUNT aggregate?
  13. SQL SELECT speed int vs varchar
  14. delete “column does not exist”
  15. How to create a temporary function in PostgreSQL?
  16. Postgres Case Sensitivity
  17. Polymorphism in SQL database tables?
  18. Record returned from function has columns concatenated
  19. INSERT rows into multiple tables in a single query, selecting from an involved table
  20. How to find a table having a specific column in postgresql
  21. postgresql: INSERT INTO … (SELECT * …)
  22. PostgreSQL JOIN with array type with array elements order, how to implement?
  23. Trim trailing spaces with PostgreSQL
  24. Return multiple columns and rows from a function PostgreSQL instead of record
  25. Postgres error updating column data
  26. Check whether string is a date Postgresql
  27. SQL LIKE condition to check for integer?
  28. Return rows from INSERT with ON CONFLICT without needing to update
  29. Insert data and set foreign keys with Postgres
  30. How to use a ring data structure in window functions

Leave a Comment