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
