On Wed, 9 Jun 2021 14:51:46 -0500 Hassan Camacho Cadre <hccadre@xxxxxxxxx> wrote: > Hello > > > I recently installed a postgreSQL v12, in previous version 8.3 in all my > queries I pass parameters using the character : > > SELECT > > public.tabla.id > > FROM > > public.tabla > > WHERE > > public.tabla.id = :a > > In the new version when I try to make this query it sends me an error > > ERROR syntax error at or near ":" > [...] > I am executing this query on the query editor of pgadmin 4 The :varname syntaxe is only understood by psql, which parse it and replace it with the value BEFORE sending the query to postgres. pgAdmin doesn't know this syntaxe. If you need to parameterize a query in pure SQL, use PREPARE/EXECUTE. Regards,
