From: | Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is statement ID of table? |
Date: | 2009-10-11 16:00:42 |
Message-ID: | c11950270910110900q373139cx7535f3b9dbbba6ef@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
associated with prepared query(not table) to improve performance of building
query. I just need to find plan using statement ID and execute it. I don't
know how to do this.
Thanks,
Jignesh
On Sun, Oct 11, 2009 at 8:06 PM, A. Kretschmer <
andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> In response to Jignesh Shah :
> > Hi,
> >
> > Could any one please tell me what is statement ID of table?
>
> There isn't such ID, but every table has an OID, an Object Identifier.
>
>
> > How to get it and
>
> The (hidden) column "oid" of pg_class contains this OID.
>
>
> > in which scenarios it can be helpful? Any documentation or example about
>
> I think, you don't need this, it is only for internal.
>
> http://www.postgresql.org/docs/8.4/interactive/datatype-oid.html
>
>
> Regards, Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Otandeka Simon Peter | 2009-10-11 17:05:49 | Granting rights |
Previous Message | Tom Lane | 2009-10-11 15:37:03 | Re: Convert DECIMAL MySql field to PostGre. How? |