Postgresql - Inline comment in VIEW Sql definition

From: vikram singh chandel <vikramschandel(at)outlook(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Postgresql - Inline comment in VIEW Sql definition
Date: 2016-04-04 13:31:27
Message-ID: BM1PR01MB03712480290CA7C12F0E3722CC9D0@BM1PR01MB0371.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello Team,

PostgreSQL does not allow to strore inline comments in view's SQL definition, because the CREATE VIEW statement is parsed, and then analyzed to see what table and other database objects are referenced, and then the analyzed parse-tree is saved.

However in our application we have designed one process which uses the tags that we mention within comments as part of CREATE VIEW definition. Things were going on good in Oracle database as it stored inline comments also. During migration we are unable to port one of our functionality which have dependency on comments in View in Postgres it didn't save the comments.

Do we have anyway to get the actual VIEW text in Postgres db.

Thanks

Vikram

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2016-04-04 14:10:06 Re: Postgresql - Inline comment in VIEW Sql definition
Previous Message JORGE MALDONADO 2016-04-02 23:24:49 unrecognized configuration parameter "autocommit"