Postgres 12.4 inner join with where statement = 'string' returning error

From: VAE Ventures <vaeventures(at)outlook(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Postgres 12.4 inner join with where statement = 'string' returning error
Date: 2021-01-04 01:33:22
Message-ID: BL0PR02MB537917C08B815DEF89BF99D7B6D20@BL0PR02MB5379.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am running a db on postgres12.4

I have been trying to run a query that looks like this:

SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = ‘string’;

I am being returned:

ERROR: column 'string' does not exist

The following queries work fine:

SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = int;

SELECT * FROM table_1 WHERE column = ‘string’;

I read several posts about this error, which seems very common and is usually solved by switching up quotation variations around the table name, column name, and the name of the string I am querying for. I have tried every variation of double and single quotes around each table name, column name, and name of string, and nothing worked.

For some reason, it seems that querying for a string is what is throwing everything off. I am new to postgres, am I missing something? Appreciate any advice possible

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2021-01-04 02:45:08 Re: Postgres 12.4 inner join with where statement = 'string' returning error
Previous Message Magnus Hagander 2021-01-02 11:50:06 Re: recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751)