Re: Schema variables - new implementation for Postgres 15 - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Schema variables - new implementation for Postgres 15
Date
Msg-id CAB-JLwaZV-tMdq=5T3JnjDsOMGecAAH_k9_T9SFep=LwcD4A+Q@mail.gmail.com
Whole thread Raw
In response to Re: Schema variables - new implementation for Postgres 15  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Schema variables - new implementation for Postgres 15
Re: Schema variables - new implementation for Postgres 15
List pgsql-hackers
For example, if I define a variable called "relkind", then psql's \sv
meta-command is broken because the query it performs can't distinguish
between the column and the variable.

If variables use : as prefix you´ll never have these conflicts.

select relkind from pg_class where relkind = :relkind

 

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Printing backtrace of postgres processes
Next
From: Julien Rouhaud
Date:
Subject: Re: Schema variables - new implementation for Postgres 15