From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
cc: =?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= <prevostclement@gmail.com>,
 pgsql-docs@postgresql.org
Subject: Re: Documentation on information_ schema columns that does not exist
In-reply-to: <32009.1433109284@sss.pgh.pa.us>
References: 
 <CABaKae8+p6=zhCM=Qrq_GMN88pFqjb5EgHpy9bjGaKZfvJmzZA@mail.gmail.com>
 <32009.1433109284@sss.pgh.pa.us>
Comments: In-reply-to Tom Lane <tgl@sss.pgh.pa.us>
 message dated "Sun, 31 May 2015 17:54:44 -0400"
Date: Sun, 31 May 2015 18:14:31 -0400
Message-ID: <32511.1433110471@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

I wrote:
> Another problem in the same area is that the column types of
> foreign_table_schema and foreign_table_name seem to be "name":

Further pursuant to that, these are the information_schema columns
that don't seem to have been cast to the spec-required type:

 column_options            | column_name          | name
 column_options            | table_name           | name
 column_options            | table_schema         | name
 foreign_table_options     | foreign_table_name   | name
 foreign_table_options     | foreign_table_schema | name
 foreign_tables            | foreign_table_name   | name
 foreign_tables            | foreign_table_schema | name

			regards, tom lane


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs