Porting from Mysql to Postgres

Hi,

I'm in the midst of porting Dbjay, a java based frontend, from MySQL to
Postgres. More info about dbjay can be found at http://www.dbjay.com.

1. When I insert a CHAR field and then fetch it, I find out that
the server padded it with spaces to the size of the field. This
happens in Postgres but not in MySQL. I'm using String.trim() on
it on the Java side. Is there a better way to do this, like setting
a flag to tell the server to trim?

2. Looking at the JDBC code it looks like getTableName in a resultset
returns "" rather than the table name. This is a big problem, cause
without the tablename it's impossible to let the user update the
resultset when the table name is unknown. Seeing that php doesn't
offer it and looking at the backend code, it looks like it's both
not Java specific and not easy to implement. Still, what are the
chances of having this available?

3. Once Dbjay is available what are the appropriate newsgroups and
mailing lists to announce it to the Postgres community.

Thanks,

Dror

Dror Matalon