Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: BUG #18038: Aliases removed from view definitions
Date
Msg-id 3b7f2fc7fe1364c6dddcdcb7458235047609b61c.camel@cybertec.at
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 Fri, 2023-07-28 at 07:33 +0200, Asier Lostalé wrote:
> Is there any way to get the original sql text used to create the view?

PostgreSQL does not retain that information.

Perhaps you could use comments:

  COMMENT ON VIEW whatever IS 'source code';

Yours,
Laurenz Albe

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18038: Aliases removed from view definitions
Next
From: Jeff Janes
Date:
Subject: Re: Question about double table scans for a table