update_postgresql_table_comment


Description

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

Parameters

Name Type Mode
table_schema text IN
table_name text IN
table_comment text IN
table_type text IN

Definition