1

I have a detailed view of the database when I use the PgAdmin in OS X:

enter image description here

However, all the properties like functions, procedures, etc don't available from the DBevear app and only see the tables for the respective schema:

enter image description here

I have to remove and re-installed the app again to the system and it doesn't help.

How do I fix this and if not possible, what are the alternatives that I can use instead of DBvear?

Arefe
  • 11,321
  • 18
  • 114
  • 168
  • I personally prefer pgAdmin over DBevear. You can also use DataGrip by jetBrains if you can afford a license :) – Rabhi salim Nov 25 '20 at 14:41
  • pgAdmin is fine but it works in the browser and I prefer to use a desktop app. I have a license for the Jetbrain, so I will try the DataGrip as suggested. – Arefe Nov 25 '20 at 14:50
  • DataGrip is faster and have a lot of tools... For pgAdmin it can be ran as an app by following this: https://stackoverflow.com/a/52905092/6150881 – Rabhi salim Nov 25 '20 at 14:54

1 Answers1

1

its a setting in your connection-settings, so right click on "billing -localhost" (the connection to the db) choose "edit connection" -> general ->navigator view -> set it to advanced

enter image description here

enter image description here

enter image description here

FatFreddy
  • 1,160
  • 1
  • 9
  • 16