Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Describe objects in SQL Developer for PostgreSQL

d21d5131-5fc1-401d-8121-99c2ed7b6255Aug 25 2017 — edited Sep 19 2017

Hi All,

I am using sql developer 4.1.3.20 with Enterprise DB (PostgreSQL). May I know how to describe a table/function for PostgreSQL, generally I use to use Shift+F4/(Right click, Popup Describe) for Oracle DB.  Help to let me know how to describe objects for PostgreSQL using sql developer.

Currently I am using to get the table columns from ALL_TAB_COLUMNS or by expanding from the left side navigation pane.

But looking for popup window type description.

Thanks,

Anil

Comments

Murali Pasumarti

You are almost there, try the below,

Equals(Integer,PropValue(Core.Children),0)

(Or) you can execute a Query with #Children Equal 0.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2017
Added on Aug 25 2017
2 comments
1,194 views