From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: MAJUMDER, SAYAN <sayan.a.majumder@capgemini.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: User defined table is not present in postgresql.
Date: Tue, 28 Mar 2017 12:27:36 -0400
Message-ID: <5403.1490718456@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOR=d=01JE1Tc5jzbx2pMMvNuzwrDapG3Fh0oSJoGcXyednveg@mail.gmail.com>
References: <41D6D8A91714DB4BB816A7D4AECA939909D51C96@IN-BLR-DAGND1.corp.capgemini.com>
<CAOR=d=01JE1Tc5jzbx2pMMvNuzwrDapG3Fh0oSJoGcXyednveg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Scott Marlowe <scott.marlowe@gmail.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, scott.marlowe@gmail.com, sayan.a.majumder@capgemini.com
Subject: Re: User defined table is not present in postgresql.
In-Reply-To: <5403.1490718456@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox