Thread: how to create function/procedure for commenting multiple objects (e.g., columns)

Hi colleagues,

I wanted to create a procedure or function that would facilitate my task of commenting multiple columns.

I tried to do so with the following script:
    create function comment_columns(text,text) returns text as 'comment on $1 is $2' language 'sql';

The attempt produced an error like: error at or near '$1'.

I even tried to create a C solution for this but it only caused a segmentation fault to the backend side.

Please help.

--
DONG B. CALMADA
Polmap Chief Information Officer
Institute for Popular Democracy
http://www.ipd.ph
Tel. (63-2) 4346674
Fax (63-2) 9262893
Mobile Phone No. 0917-9339099
Alternate email addresses:
dongski4martin@yahoo.com
dongski@calban.org

-----------------------------------
Information is power!  Set it free!

Dong B Calmada <dongski@popdem.org> writes:
>     create function comment_columns(text,text) returns text as 'comment on $1 is $2' language 'sql';

> The attempt produced an error like: error at or near '$1'.

Try using plpgsql's EXECUTE to do this.

            regards, tom lane