acemeicn <acemeijp@yahoo.co.jp> writes:
> I tried excuting the long sql on the console and a DB tool
> called CSE(Common SQL Environment), it worked.
> but in a java program using JDBC connection it doesn't
> work.
Possibly the folks on pgsql-jdbc could help you with that.
regards, tom lane