Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > You can set a default when you create a table. > Types, by definition, do not include a default value though. Domains can specify defaults ... although I don't think we allow domains over composite types, which perhaps is what the OP would need. His requirements are so vaguely stated that it's hard to be sure. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin