Re: Select default values

Hi,

> begin
> insert ...
> rollback;
>
> it's not best solution, but it just works.

Ah, yes, of course, haven't thought of that.

Okay, here is one final (i hope) obstacle. My db has >200 tables and I'd
love to be able to write some function that would just take a tablename and
return the default values for a new record of that table. If "Select default
values from sometable" was supported than that would be a piece of cake (I'd
just do: Execute "Select default values from '||sometable||' into
somerecord" in a plpgsql function).

With your way (insert into f(a,b) values(default, default) returning *) i
need to know everything about the given table.

Hmm. Any ideas?

Best,

Maximilian Tyrtania