Dean Rasheed <dean.a.rash...@gmail.com> wrote: > So that just leaves this sort of thing: > > explain (format yaml) select * from foo as "123"; What about other quoted identifiers? If I recall correctly, a quoted identifier can contain *any* characters (although a quote must be represented as two adjacent quotes). test=# create schema "0"; CREATE SCHEMA test=# create table "0"."123" ("456" int primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "123_pkey" for table "123" CREATE TABLE test=# explain (format yaml) select * from "0"."123" where "456" = '789'; QUERY PLAN ----------------------------------- - Plan: + Node Type: Index Scan + Scan Direction: Forward + Index Name: "\"123_pkey\"" + Relation Name: 123 + Alias: 123 + Startup Cost: 0.00 + Total Cost: 8.27 + Plan Rows: 1 + Plan Width: 4 + Index Cond: "(\"456\" = 789)" (1 row) Also, the trailing spaces in this format (stripped from this email to avoid odd spacing) are more than a little annoying.
-Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs