Skip to main content
Database Administrators
Seperman's user avatar
Seperman's user avatar
Seperman's user avatar
Seperman
  • Member for 5 years, 8 months
  • Last seen this week
Profile Activity

12 Actions

All Accepts Posts Badges Comments Revisions Reviews Suggestions
awarded
 Editor
awarded
 Scholar
awarded
 Student
accepted
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?
comment
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?
Thanks for the new query. So the column name in showing up in the argument_columns array, but if argument_columns is null, then it shows up as a string (not array) in the column_names?
comment
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?
Thanks @jeff-vermeer I was hoping for something simpler. I think what I am going to do is to parse the index definition in Python and extract the information I need without using regex. I try to stay away from Regex unless there is no choice.
revised
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?
added 2 characters in body
comment
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?
@nbk Sure. Added the details!
revised
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?
added 279 characters in body
asked
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?
awarded
 Supporter
awarded
 Autobiographer