PostgreSQL与SQL Developer问题 [英] PostgreSQL with SQL Developer Issue

问题描述

我为PostgreSQL添加了我的第三方JDBC驱动程序，该选项卡出现了.

I added my Third Party JDBC drivers for PostgreSQL, the tab shows up.

但是，在我填写用户名/密码和主机名/端口，然后选择选择数据库后，我得到:

However, after I fill in the Username/Pwd and Hostname/Port and then select Choose Database - I get:

Failure -FATAL: database "user1" does not exist

还有其他人遇到这个问题吗?

Anyone else having this issue?

我正在使用的JDBC驱动程序是postgresql-8.4-701.jdbc4.jar.

The JDBC driver I am using is postgresql-8.4-701.jdbc4.jar.

推荐答案

如果您具有不同的用户名和数据库名，则SQLDevelopper 4.1可以与此工作环境一起使用:

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

username: testuser
password: mypass
Host: 127.0.0.1:1234/testdb?
Port: 1234

别忘了?"特点. 然后选择数据库"变得可用，并且连接正常.

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

感谢Piperopoulos在这篇文章中为我提供了帮助: Oracle SQL Developer和PostgreSQL

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

请注意，SQLDevelopper未列出架构和表. 您可以使用此请求将其手动列出:

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与SQL Developer问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！