Re: Select default values

Hello

2008/7/23 Maximilian Tyrtania <maximilian.tyrtania@onlinehome.de>:
> 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" ?
> Unfortunately this syntax doesn't seem to be supported. I know i can select
> the default values for each column, but being able to select them in one go
> would be handy...


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
>
> tia,
>
> 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
>