Good morning,
May I know the "commands" to
. show current session's prepared plans
. see the definition of a prepared plan
E.g., psql> PREPARE fooplan (int, text, bool, numeric) AS INSERT INTO
foo VALUES($1, $2, $3, $4);
(1) Similar to "\dt", I want to see "fooplan"
(2) Similar to "\d tableNa
On Wed, Jul 23, 2008 at 3:57 AM, Maximilian Tyrtania
<[EMAIL PROTECTED]> wrote:
> Hi,
>
>> am Wed, dem 23.07.2008, um 10:32:58 +0200 mailte Maximilian Tyrtania
>> folgendes:
>>> Hi there, just a quickie: Is there a way to select all default values of a
>>> given table? Something like "Select Defau
Pavel,
fantastic, that's exactly what I wanted, thank you very much!
Maximilian Tyrtania
> Von: Pavel Stehule <[EMAIL PROTECTED]>
>> 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
2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
> 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
On Wed, Jul 23, 2008 at 12:35:08PM +0200, Maximilian Tyrtania wrote:
> With your way (insert into f(a,b) values(default, default) returning *) i
> need to know everything about the given table.
>
> Hmm. Any ideas?
Do look at the information schema.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.n
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 de
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 sy
Hi,
> am Wed, dem 23.07.2008, um 10:32:58 +0200 mailte Maximilian Tyrtania
> folgendes:
>> 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" ?
>
> test=# create table t_with_defaults( s1 int default 1
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 defaul
Hello
2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
> 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 v
am Wed, dem 23.07.2008, um 10:32:58 +0200 mailte Maximilian Tyrtania folgendes:
> 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
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
wou
12 matches
Mail list logo
