Horton
Menu

Re: How do I upsert depending on a second table?

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Samuel Marks <samuelmarks@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Date: 2025-09-23T21:00:50Z
Lists: pgsql-general 
On 9/23/25 13:56, Samuel Marks wrote:
> the AS syntax can alternatively be used for aliases
> https://www.postgresql.org/docs/current/sql-select.html
> 
> `SELECT actual_tablename table0 WHERE table0.column00 = 1`

Ok, I missed the:

... FROM org org_tbl ...
> 
> (I used a space)

Yeah, I use tbl_name AS alias_name to help these old eyes catch this 
sort of thing in my queries.



-- 
Adrian Klaver
adrian.klaver@aklaver.com