Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect to a PostgreSQL database?

Jay~DMay 4 2023

How to connect to a PostgreSQL database using sqlcl?

SQL> show version
Oracle SQL Developer Command Line (SQLcl) Version: 23.1.0.0 Build: 23.1.0.89.0930

A JDBC driver postgresql-42.6.0.jar was copied to <sqlcl-root>/lib/drivers.

sql /nolog
connect -v -t <username>@jdbc:postgresql://<host>:<port>/<database>

No output is shown. I'm still not connected.

A logon using the same JDBC driver in SQL Developer Version 23.1.0.097 is working fine.

Comments
Post Details
Added on May 4 2023
1 comment
903 views