2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
> 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
>
>
>

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to