Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> 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