Custom Variables in Postgres

--set a session variable
set mycustom.var = 'value';

--display it
show mycustom.var; 

--use it
select * from mytable where some_column = current_setting('mycustom.var');

For PG 9.1 or earlier, you would have to add/change this in postgresql.conf:

custom_variable_classes = 'mycustom[,...]'

Restart or SELECT pg_reload_conf();

Martin Fowler on User-Defined Fields

http://martinfowler.com/bliki/UserDefinedField.html

Essentially, he recommends using an XML field, or allowing the user to ALTER their own schema.

Add comments to tables and columns with PostgreSQL

create table some_table(
  some_column int
);
comment on table some_table is 'some table comment';

comment on column some_table.some_column is 'some column comment';