Re: Get original view definition without modification

2020-05-29 Thread Tom Lane
PG Doc comments form writes: > I am looking a way to get exact view definition, for ex : > ... > I am fine with adding tablename before columnname but i don't want the extra > '::text' part. Is there anyway to achieve this(like any other system table i > can query from to get original definition)

Re: max_wal_size

2020-05-29 Thread p . luzanov
David, I don't know whether a change along those lines to the configuration reference page is useful or not - I wouldn't make one without a comprehensive re-read of the actual background/learning section of the documentation. My gut instinct is that I just don't think the documentation can do

Re: descriptions of pg_stat_user_functions and pg_stat_slru

2020-05-29 Thread Fujii Masao
On 2020/05/27 12:17, Fujii Masao wrote: On 2020/05/25 14:23, Fujii Masao wrote: On 2020/05/22 22:35, Fujii Masao wrote: On 2020/05/21 4:53, Tom Lane wrote: Fujii Masao writes: On 2020/05/20 22:32, Tom Lane wrote: OK by me --- that, too, would be more like the existing catalogs

Get original view definition without modification

2020-05-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/rules-views.html Description: I am looking a way to get exact view definition, for ex : CREATE TABLE t1(id int,name varchar); INSERT INTO t1 values(1,'n1'),(2,'n2'); CREATE