Postgres Pro
Downloads
Home   >   mailing lists

Re: how to create function/procedure for commenting multiple objects (e.g., columns) - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to create function/procedure for commenting multiple objects (e.g., columns)
Date
Msg-id 10579.1002818341@sss.pgh.pa.us
Whole thread Raw
In response to how to create function/procedure for commenting multiple objects (e.g., columns)  (Dong B Calmada <dongski@popdem.org>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Alter column / array
Next
From: Heitzso
Date:
Subject: re logging, how does one cleanup the write ahead and other logs