7

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?

gmsi
  • 1,062
  • 1
  • 16
  • 29
  • 2
    Please try to invoke *Synchronize* action for the PostgreSQL data source and then View | Quick Documentation. – Andrey Apr 14 '16 at 10:33
  • Synchronize did not help @Andrey Thanks. – gmsi Apr 14 '16 at 13:23
  • Can you file an issue at https://youtrack.jetbrains.com/issues/DBE with the actual DDL for the view and results of *Test Connection* output for Postgres data source? We will check it. Thanks. – Andrey Apr 15 '16 at 20:49
  • What about DDL tab in Table Viewer? The same? – moscas Apr 25 '16 at 14:36
  • @moscas For tables, DDL works. Thanks – gmsi Apr 25 '16 at 15:15
  • 4
    I mean — double click on view and then DDL tab like here — https://twitter.com/0xdbe/status/724602466969497601 – moscas Apr 25 '16 at 15:44
  • I took 2016.1 update and get the message on DDL tab "-- definition is not available or empty" – gmsi Apr 25 '16 at 15:59

1 Answers1

3

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
Quintin Botes
  • 353
  • 3
  • 10