Thread: What is statement ID of table?

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)

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

In response to Jignesh Shah :
> 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.

Please, answer to the list and not to me, and please try to avoid html and
top-posting.

I don't know if i understand you correctly. There isn't such an ID, but
you can look at pg_prepared_statements, this view contains name,
statement and other informations about all (currently) prepared
statements.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)

you can create a primary key to associate with each row in the table

On 10/12/09, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
> In response to Jignesh Shah :
>> 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.
>
> Please, answer to the list and not to me, and please try to avoid html and
> top-posting.
>
> I don't know if i understand you correctly. There isn't such an ID, but
> you can look at pg_prepared_statements, this view contains name,
> statement and other informations about all (currently) prepared
> statements.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>