Questions tagged [pg-catalog]
The pg-catalog tag has no usage guidance.
5
questions
1
vote
1
answer
52
views
How to work around "row is too big" for role definitions without recreating the database?
I am running into the row is too big (ERROR: 54000: row is too big: size 9976, maximum size 8160) error in Postgres related to role permissions on a couple of my instances. I understand that after ...
- 11
2
votes
2
answers
72
views
When an index is created from a function on a column, we get the function name instead of the column name in pg_attribute in Postgres. How to fix it?
I have come up with the following query to get the table name, index_type, operator_classes, and uniqueness of indexes based on the answers mostly from @Erwin Brandstetter:
SELECT i.indrelid::regclass:...
- 123
0
votes
2
answers
521
views
How to display name and type of table columns in creation order?
I have created this tbl_cities using the code below:
CREATE TABLE IF NOT EXISTS public.tbl_Cities
(City_ID SERIAL NOT NULL,
City_Name VARCHAR(100) NOT NULL,
City_State_Region VARCHAR(100),
...
- 125
1
vote
1
answer
1k
views
Is pg_database a catalog or a table?
I am learning about PostgreSQL and am trying to understand basic concepts like schemas, catalogs and tables. I have been reading PostgreSQL: Up and Running, and to quote the book:
Schemas are ... the ...
- 203
3
votes
1
answer
5k
views
What is faster: pg_catalog or information_schema?
I understand the high-level differences between pg_catalog and information_schema.
But in many cases, a tool could choose to use any of them. And I'm wondering if there are performance reasons why we ...
- 1,723