PostgreSQL with SQL Developer Issue

If you have a different user and db name, SQLDevelopper 4.1 works with this workarround:

username: testuserpassword: mypassHost: 127.0.0.1:1234/testdb?Port: 1234

Don't forget the "?" character.Then Select Database becomes available and connection works.

Thanks to Piperopoulos who helped me in this post: Oracle SQL Developer and PostgreSQL

Note that schema and tables are not listed by SQLDevelopper.You can use this request to list them manually:

select * from pg_catalog.pg_tables;

postgresql oracle-sqldeveloper

This is a comment- try psql -u user1 in command line to check whether user exist

CodeHunter