What is the difference between single quotes and double quotes in PostgreSQL?

by

Double quotes are for names of tables or fields. Sometimes You can omit them. The single quotes are for string constants. This is the SQL standard. In the verbose form, your query looks like this:

select * from "employee" where "employee_name"='elina';

More Related Contents:

  1. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  2. How to check if a table exists in a given schema
  3. Save PL/pgSQL output from PostgreSQL to a CSV file
  4. Difference between language sql and language plpgsql in PostgreSQL functions
  5. Optimize query with OFFSET on large table
  6. GROUP BY and aggregate sequential numeric values
  7. Safely rename tables using serial primary key columns
  8. How to concatenate columns in a Postgres SELECT?
  9. How to use (install) dblink in PostgreSQL?
  10. get JOIN table as array of results with PostgreSQL/NodeJS
  11. How can I send email from PostgreSQL trigger?
  12. PostgreSQL multi INSERT…RETURNING with multiple columns
  13. Postgres manually alter sequence
  14. What’s the proper index for querying structures in arrays in Postgres jsonb?
  15. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  16. Oracle equivalent of Postgres’ DISTINCT ON?
  17. Combine two columns and add into one new column
  18. Bulk/batch update/upsert in PostgreSQL
  19. Grant privileges for a particular database in PostgreSQL
  20. Functions with variable number of input parameters
  21. Timestamp Difference In Hours for PostgreSQL
  22. How to compare dates in datetime fields in Postgresql?
  23. What is the fastest way to truncate timestamps to 5 minutes in Postgres?
  24. Getting results between two dates in PostgreSQL
  25. How to perform a select query in a DO block?
  26. Postgres trigger after insert accessing NEW
  27. Cannot SELECT from UPDATE RETURNING clause in postgres
  28. Subtract hours from the now() function
  29. Query for count of distinct values in a rolling date range
  30. SQL Populate table with random data

Leave a Comment