Thread: inquiry
<p>Dear Momjian，<p>hello,<p>I want to make the show variable SQL to return message like pgresult. how can I revise the sourcecode? Any suggestion?<p>I really need you help.<p>Jinqiang Han
thank you for your information.
I want to use the imformation of show or other utilities sql in jdbc interface. generally resultset is empty when such sql is execute. I want to get the information like psql. How can I do?
Thanks again.
You should ask this on general, and be more specific about how pgresult
is different from that SHOW currently does.
Due to time constraints, I do not directly answer general PostgreSQL
questions. For assistance, please join the appropriate mailing list and
post your question:
http://www.postgresql.org/users-lounge
You can also try the #postgresql IRC channel. See the PostgreSQL FAQ
for more information.
---------------------------------------------------------------------------
[ ?GB2312?] wrote:
>> Dear Momjian，
>> hello,
>> I want to make the show variable SQL to return message like pgresult. how can I revise the source code? Any suggestion?
>> I really need you help.
>> Jinqiang Han
>>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In 7.3, SHOW returns a query results that can be resturned to jdbc. We are using beta1/2 now, so you can test that from ftp.postgresql.org. --------------------------------------------------------------------------- [ ?GB2312?] wrote: > thank you for your information. > I want to use the imformation of show or other utilities sql in jdbc interface. generally resultset is empty when suchsql is execute. I want to get the information like psql. How can I do? > Thanks again. > > > > You should ask this on general, and be more specific about how pgresult > is different from that SHOW currently does. > > Due to time constraints, I do not directly answer general PostgreSQL > questions. For assistance, please join the appropriate mailing list and > post your question: > > http://www.postgresql.org/users-lounge > > You can also try the #postgresql IRC channel. See the PostgreSQL FAQ > for more information. > > --------------------------------------------------------------------------- > > > [ ?GB2312?] wrote: > >> Dear Momjian�� > >> hello, > >> I want to make the show variable SQL to return message like pgresult. how can I revise the source code? Any suggestion? > >> I really need you help. > >> Jinqiang Han > >> > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073