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: 162867790807230319q2002719aq9ded4dc7b7f7cb24@mail.gmail.com (view raw or flat)
Thread:
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);
>> CREATE TABLE
>> 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..

begin
  insert ...
 rollback;

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

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

In response to

Responses

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-2014 The PostgreSQL Global Development Group