On 09/01/2014 20:16, Raymond O'Donnell wrote: > On 09/01/2014 20:08, Brooke Beacham wrote: >> Can anyone suggest a way to associate a set of custom properties >> (key/value pairs) with a column's definition (ie pg_attribute)? >> >> (without having to replicate/maintain a table of columns separately from >> the system catalog) >> >> For example: >> * I have a table with 50 columns >> * I'd like to 'flag' 30 of those columns as group - 'A' and the other 20 >> as group - 'B' >> >> >> So I'd like a way to add custom metdata (k/v pairs) to a column's >> definition (not the actual rows of data). > > You could use the comment facility - > > COMMENT ON COLUMN tablename.columnname IS IS '....'; Whoops, sorry, an extra "is" got in there.... should have been: COMMENT ON COLUMN tablename.columnname IS '....'; Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
