Re: select only default - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: select only default
Date
Msg-id 20030516023059.GA23312@wolff.to
Whole thread Raw
In response to select only default  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
On Fri, May 16, 2003 at 01:32:03 +0200,
  Nabil Sayegh <postgresql@e-trolley.de> wrote:
> Hi all,
>
> just for curiosity:
>
> Is it possible to SELECT a row that consists only of default values of a
> table ?

There is probably some way to get the data out of the system tables. If
the defaults are constants you might be able to easily present it.

However, for what you are doing it may be better to put the defaults
in a separate table and get them from there. You will have to create
a function(s) for getting the default values since you can't use
select in a default clause.

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: select only default
Next
From: "Ville Jungman"
Date:
Subject: Re: select only default