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
