0

I am using PostGIS, so my database has about 1K functions.

enter image description here

Looking for "my" functions in that mess is annoying. Can I somehow group or hide some functions? I was thinking of a functionality I'd seen in an SQL Server plugin. Maybe something similar for pgAdmin4 exists?

1 Answer 1

0

While not an 100% answer to the exact question, it seems that at least PostGIS functions can be "grouped" in a schema of my choice if it's at least PostGIS 2.3:

https://postgis.net/2017/11/07/tip-move-postgis-schema/

The main points of the above link:

CREATE SCHEMA postgis;
 
ALTER DATABASE mydb 
SET search_path = public,postgis;

UPDATE pg_extension 
  SET extrelocatable = TRUE 
    WHERE extname = 'postgis';
 
ALTER EXTENSION postgis 
  SET SCHEMA postgis;
 
ALTER EXTENSION postgis 
  UPDATE TO "2.4.1next";
 
ALTER EXTENSION postgis 
  UPDATE TO "2.4.1";

This will move all PostGIS functions to a scheme named "PostGIS", that pgadmin can expand/collapse.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .