Re: User defined table is not present in postgresql.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "MAJUMDER, SAYAN" <sayan(dot)a(dot)majumder(at)capgemini(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: User defined table is not present in postgresql.
Date: 2017-03-28 16:27:36
Message-ID: 5403.1490718456@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-03-28 18:21:20 Re: ERROR: XX000: cache lookup failed for index 2399344195
Previous Message Scott Marlowe 2017-03-28 16:19:53 Re: User defined table is not present in postgresql.