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

From: Dong B Calmada <dongski(at)popdem(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to create function/procedure for commenting multiple objects (e.g., columns)
Date: 2001-10-11 07:48:56
Message-ID: 20011011154856.A892@dongski.popdem.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)yahoo(dot)com
dongski(at)calban(dot)org

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Heitzso 2001-10-11 12:57:18 re logging, how does one cleanup the write ahead and other logs
Previous Message Rolf Lüttecke 2001-10-11 07:12:17 Alter column / array