Error: Column does not exist

by

When it comes to Postgresql and entity names (Tables, Columns, etc.) with UPPER CASE letters, you need to “escape” the word by placing it in “”. Please refer to the documentation on this particular subject. So, your example would be written like this:

String stm = "DELETE FROM hostdetails WHERE \"MAC\" = 'kzhdf'";

On a side note, considering you are using prepared statements, you should not be setting the value directly in your SQL statement. 

con = DriverManager.getConnection(url, user, password);
String stm = "DELETE FROM hostdetails WHERE \"MAC\" = ?";
pst = con.prepareStatement(stm);
pst.setString(1, "kzhdf");
pst.executeUpdate();

More Related Contents:

  1. PostgreSQL “Column does not exist” but it actually does
  2. sql statement error: “column .. does not exist”
  3. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  4. Does the JDBC spec prevent ‘?’ from being used as an operator (outside of quotes)?
  5. I keep getting the error “relation [TABLE] does not exist”
  6. Postgresql Column Not Found, But Shows in Describe
  7. PostgreSQL column ‘foo’ does not exist
  8. Sort by column ASC, but NULL values first?
  9. Cannot simply use PostgreSQL table name (“relation does not exist”)
  10. Using an Alias column in the where clause in Postgresql
  11. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  12. Optimize query with OFFSET on large table
  13. How to concatenate columns in a Postgres SELECT?
  14. updating table rows in postgres using subquery
  15. Find overlapping date ranges in PostgreSQL
  16. PostgreSQL multi INSERT…RETURNING with multiple columns
  17. How do you do date math that ignores the year?
  18. “Operator does not exist: integer =?” when using Postgres
  19. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  20. Oracle equivalent of Postgres’ DISTINCT ON?
  21. postgresql generate sequence with no gap
  22. Aggregate a single column in query with many columns
  23. Aggregating (x,y) coordinate point clouds in PostgreSQL
  24. PostgreSQL convert columns to rows? Transpose?
  25. Regular expression in PostgreSQL LIKE clause
  26. Postgres Error: More than one row returned by a subquery used as an expression
  27. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  28. How to detect query which holds the lock in Postgres?
  29. PostgreSQL how to create a copy of a database or schema?
  30. PostgreSQL: top n entries per item in same table

Leave a Comment