Parameters
Name | Type | Mode |
---|---|---|
table_schema | text | IN |
table_name | text | IN |
table_comment | text | IN |
table_type | text | IN |
Update the PostgreSQL comment of a table by giving table schema, name and comment
Example: if you need to update the comments for all the items listed by pgmetadata.v_table_comment_from_metadata:
SELECT
v.table_schema,
v.table_name,
pgmetadata.update_postgresql_table_comment(
v.table_schema,
v.table_name,
v.table_comment,
v.table_type
) AS comment_updated
FROM pgmetadata.v_table_comment_from_metadata AS v
Name | Type | Mode |
---|---|---|
table_schema | text | IN |
table_name | text | IN |
table_comment | text | IN |
table_type | text | IN |