Script scheme of the entire database with Datagrip

Question

Is it possible to use the script scheme of an entire database (SQL Server or Postgres) with datagrip?

I know that I can get DDL for the table and view and source for each stored procedure / function.

Is it possible to get one script for all objects in the database at once?

Alternatively, is there a way to find the code for all the routines at once, say I need to find which ones use #table temp table?

Answer 1

I searched for it today and just found it. If you right-click on the scheme you want to copy and select "Copy DDL", this will copy the creation of the script to the clipboard.

Answer 2

To answer the second part of the question: a quick and easy way to search #table in all of your procedures, you can run the following query

 SELECT * FROM information_schema.routines WHERE routine_definition LIKE '%#table%' 

Answer 3

So far, only dumping tables are working. In 2016, EAP, which will be available in late August, will be integrated with mysqldump and pg_dump.