I guess I did a faulty database restoration or the dump did not have this data and the "folder like" structure was lost. This is a capture of Dbeaver showing what I mean with "foler like" structure. I can easily access the functions, tables, schemas, etc. stored in the database definition. I'm not so worried about the loss of the original structure as it did not have much, but I do want to recreate it step by step when I need it. For example, now I made a function and would like to see it under a "Functions" folder, how can I do that?

Also, what should I have included in the pg_dump generation script to also backup this structure?


enter image description here

  • 1
    Doesn't DBeaver always show functions inside the "Functions" folder? Is the function missing, or shown somewhere else?
    – CL.
    Commented Jun 3, 2020 at 7:51
  • The "folder" structure is non existent. Only shows the schemas and tables barebones, not even a "tables" folder. Perhaps is a Dbeaver issue, will check in their forums just in case.
    – Gabriel
    Commented Jun 3, 2020 at 14:16

1 Answer 1


In the database navigator on the left, right-click on your database connection, and select "Advanced" rather than "Simple": DBeaver menu to see the "folder structure"


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.