The catalogs tag has no wiki summary.
1
vote
2answers
43 views
Dropping a group of schemas with similar name patterns
Consider a situation where one need to perform a bunch of essentially identical operations, with the only variable being the name of some object.
In my case, I need to drop some schemas, all of the ...
3
votes
2answers
48 views
disallow SET command in a postgresql server
Im planning to publish my postgresql server to a few untrusted clients.
I dont want them to modify any runtime setting, like work_mem or something risky to my server. In general I assume the ...
1
vote
2answers
77 views
Display user-defined types and their details
I've created a few new UDTs in PostgreSQL. However, now I have two problems:
how to see which UDTs have been defined?
how to see the columns defined within these UDTs?
Unfortunately, I couldn't ...
0
votes
2answers
149 views
ERROR: could not find array type for datatype information_schema.sql_identifier
I am trying to run the below sql command:
SELECT ARRAY(
SELECT column_name
FROM information_schema.columns
WHERE table_name ='gis_field_configuration_stage'
);
and I get the below ...
