Omitting the double quote to do query on PostgreSQL

by

Your problem with this query started when you created your table. When you create your table, don’t use quotes.

Use this:

CREATE TABLE a ( ... );

Not this:

CREATE TABLE "A" ( ... );

The latter will make it so that you always have to quote it later. The former makes it a normal name and you can use SELECT * FROM a; or SELECT * FROM A;

If you can’t just recreate your table, use the ALTER TABLE syntax:

ALTER TABLE "A" RENAME TO a;

More Related Contents:

  1. What to do with null values when modeling and normalizing?
  2. Postgres: INSERT if does not exist already
  3. Truncating all tables in a Postgres database
  4. How can I drop all the tables in a PostgreSQL database?
  5. postgres default timezone
  6. How to change PostgreSQL user password?
  7. How to get the count of current month Sunday’s in psql?
  8. Restore a postgres backup file using the command line?
  9. How to close idle connections in PostgreSQL automatically?
  10. Refresh a materialized view automatically using a rule or notify
  11. postgresql – replace all instances of a string within text field
  12. Is it possible to have autoincrement number without it being an ID?
  13. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  14. pgadmin4 : postgresql application server could not be contacted.
  15. PostgreSQL error ‘Could not connect to server: No such file or directory’
  16. Insert if not exists, else return id in postgresql
  17. function returns multiple columns as a single column instead of multiple columns
  18. Sequences not affected by transactions?
  19. Postgres: check if array field contains value?
  20. Dynamic pivot query using PostgreSQL 9.3
  21. Storing Images in PostgreSQL
  22. Psql could not connect to server: No such file or directory, 5432 error?
  23. Postgres: Distinct but only for one column
  24. In PostgreSQL, how to insert data with COPY command?
  25. How to add column if not exists on PostgreSQL?
  26. Maximum characters in labels (table names, columns etc)
  27. Docker – Postgres and pgAdmin 4 : Connection refused
  28. How to work with PGpoint for Geolocation using PostgreSQL?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment