Get original view definition without modification

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: shandeep2846(at)gmail(dot)com
Subject: Get original view definition without modification
Date: 2020-05-29 05:55:57
Message-ID: 159073175748.7034.16685684549743853062@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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 VIEW v2 AS SELECT * FROM t1 WHERE name = 'n1';

But when i checked the definition in postgresql DB(9.5) in pg_views
table, it is getting modified in the below way :
postgres=# select * from pg_views where schemaname = 'sc1' and viewname
= 'v2';
schemaname | viewname | viewowner | definition

------------+----------+-----------+-----------------------------------------
sc1 | v2 | postgres | SELECT t1.id,
+
| | | t1.name
+
| | | FROM sc1.t1
+
| | | WHERE ((t1.name)::text =
'n1'::text);
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)

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2020-05-29 08:16:18 Re: descriptions of pg_stat_user_functions and pg_stat_slru
Previous Message Fujii Masao 2020-05-29 04:13:34 Re: wal_init_zero and wal_recycle