Re: What is statement ID of table?
От | paragasu |
---|---|
Тема | Re: What is statement ID of table? |
Дата | |
Msg-id | 89b35b8d0910112340v6a0fc470p527ffb35769227cb@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: What is statement ID of table? ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: