ETL and Data Integration tools - Modern ETL software for everyone

I connect to the database direct with the PostgreSQL Driver without the use of ODBC.
Everything works fine. All Tables are shown.

Unfortunately when i try to open an table which is not in the default "public" schema it doesn't work.
When i click on the table i get this sql statement: "select table1.* from table1" but it should be
"select schema1.table1.* from schema1.table1"

So I get an error that table1 not exists.

If i try to connect with ODBC I can open tables from other views, but the problem here is, that the width of
a field with an text or character varying format doesn't fit into the window. So I first have to adjust the width
of all fields. This method is unsuitable. With the direct connection via the PostgreSQL Driver it works fine.

I'll hope there is a possibility to open tables from other views.

This will relevant to our ETL tools as well
We will have a look at this one for you

Mike

Can you try Database Browser Portable 3.2.2.13
www.dbsoftlab.com/dmdocuments/DatabaseBr...2.13_English.paf.exe

Changes are
Support for PosgreSQL 9 was introduced
Works correctly with multiple PosgreSQL schemes
Support for German Locale was introduced
Title Menu
Select all and copy from data grid

Please let us know the outcome
Mike

Thank you for the fast reply and the fast solution.

Now the access to multiply schemes works fine.

I use PostgreSQL 8.1

Congratulation for this great Tool.

I found an additional issue. In my database there is a field "entrystatus" with the value "NEW", "UPDATE" or "DELETE"
When I click at the Filter drop down field, I get check boxes with these values. But when I click at a check box, I get an error: "Type mismatch in expression". This error is only with fields which data type are character varying, text...
With Integer I have no troubles.

By clicking the check box, the filter is "='UPDATE'" but it should be ~'UPDATE' for the data type character varying

This issue is not a great one, It's also easy to type in manually the Filter.

thank you for your support

Br

Martin

I also had the same problem, but thanks to this thead i solved it... many thanks to the developers... dbbrowser is a great life saver

Thank you very much

Your support and feedback means a lot to us

Happy new year,
Mike