0

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?

Improve this question
3
  • use single quotes. Double quotes means a column name. Commented Nov 12, 2020 at 13:21
  • postgresql.org/docs/current/… Commented Nov 12, 2020 at 13:23
  • Hello JGH, i have already tried, but i got exactly the same error message. Commented Nov 13, 2020 at 8:55
Related questions
3327
How to add a column with a default value to an existing table in SQL Server?
789
psql: FATAL: role "postgres" does not exist
1109
PostgreSQL error: Fatal: role "username" does not exist
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.