When I select the View object and press "Ctrl +Q" (On Menu >> Click "View" >> Click "Quick Documentaion"), it does works for MS SQL server but not for PostgreSQL View object.
For Microsoft SQL Server, it shows correctly:
Definition:
ALTER VIEW [dbo].[StudentsView]
AS
SELECT Id, UserName, FullName, CreateDate
FROM dbo.Student
For PostgreSQL, It shows only upto view name and AS keyword.
Definition:
CREATE OR REPLACE VIEW employee.managers_vw AS
Is there a way to see the PostgreSQL VIEW object definition in datagrip?
For anyone still looking for this answer:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With