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 '....'; - to store some JSON or the like, though you'll have to parse it client-side. 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
