Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to see the PostgreSQL VIEW object definition in datagrip?

Tags:

datagrip

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?

like image 772
gmsi Avatar asked Apr 14 '16 01:04

gmsi


1 Answers

For anyone still looking for this answer:

  1. Right-Click the View in the Database window
  2. Select Open DDL in Console shortcut is Shift+F4
like image 80
Quintin Botes Avatar answered Nov 01 '22 14:11

Quintin Botes