Re: Postgresql - Inline comment in VIEW Sql definition - Mailing list pgsql-novice
Awaiting for your response 
Sent: Tuesday, April 5, 2016 1:17 PM
To: pgsql-novice@postgresql.org
Subject: Fw: Postgresql - Inline comment in VIEW Sql definition
Hi Team,
One more thing, I googled and found out few links related to "extending sql in PostgreSQL".
https://www.citusdata.com/blog/90-sql-scaling-and-whats-unique-about-postgres
 | www.citusdata.com This blog post simplifies certain concepts to be brief. If you're looking for examples on how to override the PostgreSQL planner and executor, please check out pg ... | |
It has mentioned that "Fortunately, you can change any database submodule's behavior in Postgres by intercepting the right hook." Will it be possible to go through this approach.
Please suggest.
Thanks
Vikram
Sent: Monday, April 4, 2016 7:01 PM
To: pgsql-novice@postgresql.org
Subject: Postgresql - Inline comment in VIEW Sql definition
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
Attachment
pgsql-novice by date: