From: Tom Lane <tgl@sss.pgh.pa.us>
To: shandeep2846@gmail.com
cc: pgsql-docs@lists.postgresql.org
Subject: Re: Get original view definition without modification
In-reply-to: <159073175748.7034.16685684549743853062@wrigleys.postgresql.org>
References: <159073175748.7034.16685684549743853062@wrigleys.postgresql.org>
Comments: In-reply-to PG Doc comments form <noreply@postgresql.org>
	message dated "Fri, 29 May 2020 05:55:57 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <10394.1590764802.1@sss.pgh.pa.us>
Date: Fri, 29 May 2020 11:06:42 -0400
Message-ID: <10395.1590764802@sss.pgh.pa.us>
Precedence: bulk

PG Doc comments form <noreply@postgresql.org> 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)

No, Postgres only saves a "compiled" form of a view.  Storing the original
text would have its own pitfalls, eg what if you rename a table or column
mentioned in the view?  (Also, the SQL standard has some requirements that
would be difficult to meet otherwise.)

If you really want the original text, best bet is to keep your schema
creation commands in a VCS or the like, outside the database.

			regards, tom lane