Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18038: Aliases removed from view definitions - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18038: Aliases removed from view definitions
Date
Msg-id CAKFQuwZOr76aY+hUXKZSzY2g7BEyNBmKFOYW78E13otJYi0uVQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18038: Aliases removed from view definitions  (Asier Lostalé <asier.lostale@openbravo.com>)
List pgsql-bugs
Tree view
On Thursday, July 27, 2023, Asier Lostalé <asier.lostale@openbravo.com> wrote:

Nevertheless I understand it is very fragile. Is there any way to get the original sql text used to create the view?

Your version control repository should have that.  Aside from most function bodies PostgreSQL parses and stores metadata resulting from any SQL you send it.

David J.

pgsql-bugs by date:

Previous
From: jian he
Date:
Subject: Re: Question about double table scans for a table
Next
From: Laurenz Albe
Date:
Subject: Re: BUG #18038: Aliases removed from view definitions