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

Поиск
Список
Период
Сортировка
От Dong B Calmada
Тема how to create function/procedure for commenting multiple objects (e.g., columns)
Дата
Msg-id 20011011154856.A892@dongski.popdem.org
обсуждение исходный текст
Ответы Re: how to create function/procedure for commenting multiple objects (e.g., columns)
Список 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@yahoo.com
dongski@calban.org

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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rolf Lüttecke
Дата:
Сообщение: Alter column / array
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Alter column / array