Subject: Re: optionally schema-qualified for table_name
To: Bruce Momjian <bruce@momjian.us>
References: <158399268229.5708.13296960177949398026@wrigleys.postgresql.org>
 <20200322001310.GA2031@momjian.us> <22707.1584903901@sss.pgh.pa.us>
 <20200322201518.GB2031@momjian.us> <4628.1584915604@sss.pgh.pa.us>
 <20200323012757.GC2031@momjian.us>
 <af0208b5-7811-955b-3ddf-d5839c4a4798@2ndquadrant.com>
 <20200324205818.GA32258@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, protodef@gmail.com,
 pgsql-docs@lists.postgresql.org
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <4b09907d-96de-c1da-34cd-787877503385@2ndquadrant.com>
Date: Wed, 25 Mar 2020 13:46:54 +0100
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <20200324205818.GA32258@momjian.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 2020-03-24 21:58, Bruce Momjian wrote:
> That is a good point. I used CREATE VIEW as an example because that is
> what the user reported, but it seems only create_view and reindexed use
> a schema name qualification:
> 
> 	$ grep  -l '<replaceable>schema</replaceable>' *.sgml
> 	create_view.sgml
> 	reindexdb.sgml
> 
> The reindexdb use is because of -S (reindex schema), which makes sense.
> The create view case is used in an example of CREATE RECURSIVE VIEW and
> should probably be removed.

The CREATE RECURSIVE VIEW example is making a specific point about 
schema qualification, which is explained below the example.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services