Skip site navigation (1) Skip section navigation (2)

Re: Select default values

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Maximilian Tyrtania" <maximilian(dot)tyrtania(at)onlinehome(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select default values
Date: 2008-07-23 10:19:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
2008/7/23 Maximilian Tyrtania <maximilian(dot)tyrtania(at)onlinehome(dot)de>:
> Hi again,
>>> Hi there, just a quickie: Is there a way to select all default values of a
>>> given table? Something like "Select Default values from sometable" ?
>> it's not possible directly, you can find expressions used as default
>> in system tables or
>> postgres=# create table f(a integer default 1, b integer);
>> postgres=# insert into f(a,b) values(default, default) returning *;
>>  a | b
>> ---+---
>>  1 |
>> (1 row)
>> INSERT 0 1
>> regards
>> Pavel Stehule
> ah, I see, smart, the problem with this is just that I don't actually want
> to insert the record just yet. I just want to hand the default values over
> to my app. Well, of course my app could still delete the record later on,
> but still that seems cumbersome..

  insert ...

it's not best solution, but it just works.

> Thanks a lot and best wishes from Berlin,
> Maximilian Tyrtania

In response to


pgsql-sql by date

Next:From: Maximilian TyrtaniaDate: 2008-07-23 10:35:08
Subject: Re: Select default values
Previous:From: Maximilian TyrtaniaDate: 2008-07-23 09:57:08
Subject: Re: Select default values

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group