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 |