PostgreSQL column ‘foo’ does not exist

by

You accidentally created the column name with a trailing space and presumably phpPGadmin created the column name with double quotes around it:

create table your_table (
    "foo " -- ...
)

That would give you a column that looked like it was called foo everywhere but you’d have to double quote it and include the space whenever you use it:

select ... from your_table where "foo " is not null

The best practice is to use lower case unquoted column names with PostgreSQL. There should be a setting in phpPGadmin somewhere that will tell it to not quote identifiers (such as table and column names) but alas, I don’t use phpPGadmin so I don’t where that setting is (or even if it exists).

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. I keep getting the error “relation [TABLE] does not exist”
  5. Postgresql Column Not Found, But Shows in Describe
  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. Optimize query with OFFSET on large table
  10. GROUP BY and aggregate sequential numeric values
  11. Safely rename tables using serial primary key columns
  12. How to concatenate columns in a Postgres SELECT?
  13. How to use (install) dblink in PostgreSQL?
  14. get JOIN table as array of results with PostgreSQL/NodeJS
  15. How can I send email from PostgreSQL trigger?
  16. PostgreSQL multi INSERT…RETURNING with multiple columns
  17. Postgres manually alter sequence
  18. What’s the proper index for querying structures in arrays in Postgres jsonb?
  19. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  20. Oracle equivalent of Postgres’ DISTINCT ON?
  21. Postgres sql insert query syntax error from phpPgAdmin
  22. Combine two columns and add into one new column
  23. Bulk/batch update/upsert in PostgreSQL
  24. Grant privileges for a particular database in PostgreSQL
  25. Functions with variable number of input parameters
  26. Timestamp Difference In Hours for PostgreSQL
  27. Check if NULL exists in Postgres array
  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