On 2021-Aug-28, Justin Pryzby wrote:

> Note that check constraints and indexes have the same schema as their table, 
> so
> \d doesn't show a schema at all, and quotes the name of the object.  That
> distinction may be relevant to how stats objects ended up being quoted like
> this.

Yeah, this was the rationale for including the schema name here.

I think using "%s.%s" as is done everywhere else is pretty much
pointless.  It's not usable as an object identifier, since you have to
make sure to remove the existing quotes, and unless the names work
without quotes, you have to add different quotes.  So it looks «nice»
but it's functionally more work.

-- 
Álvaro Herrera           39°49'30"S 73°17'W  —  https://www.EnterpriseDB.com/
"But static content is just dynamic content that isn't moving!"
                http://smylers.hates-software.com/2007/08/15/fe244d0c.html


Reply via email to