Postgres column "value" does not exist

Asked Nov 12 '20 at 13:15

Active Nov 13 '20 at 08:53

Viewed 495 times

I'm building a command that will execute a direct psql query on an operating system (Ubuntu) command line. Strangely enough the following error always occurs: ERROR: column "value" does not exist.

However, the query works if you are directly logged into the database.

Query:

psql -U testuser -x -c 'SELECT * FROM table where name = "value"'

I have already try different quotes , but it not works Do you have any ideas?

edited Nov 13 '20 at 08:53

asked Nov 12 '20 at 13:15

user14625987

use single quotes. Double quotes means a column name. – JGH Nov 12 '20 at 13:21
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS – Nov 12 '20 at 13:23
Hello JGH, i have already tried, but i got exactly the same error message. – user14625987 Nov 13 '20 at 08:55

Postgres column "value" does not exist

0 Answers0