Is anyone successfully using the Postgres jdbc plug with SQL developer?
I'm using postgresql-42.6.0.jar. It allows me to connect to postgres databases, fine.
But, when using a SQL worksheet, it still behaves like an oracle connection.
Example :
select '&1';
results in :
“Enter Substitution Variable. Enter value for 1”
Substitution variables are a sqlplus feature, not postgres.
There are other problems too. For instance it seems unable to parse even simple pl/pgSQL blocks - blocks that work instantly in pgAdmin.
Is anyone else successfully using the postgres plugin? Do you get these problems?
At the moment for me the plug is basically useless. You can perform simple selects, but any postgres specific code doesn't work. Seems kinda odd to me.