What is JDBC counterpart of Postgres' "\connect" command?

Question

I'm trying to execute following Postgres 9.6 commands over JDBC connection

CREATE USER my_db WITH SUPERUSER PASSWORD 'my_db';
CREATE DATABASE my_db;
GRANT ALL PRIVILEGES ON DATABASE my_db TO my_db;

\connect my_db; -- THIS ONE FAILS
SET ROLE my_db;

CREATE SCHEMA my_db AUTHORIZATION my_db;

"\connect" command fails as not recognized. Is there way to connect other database staying within the same JDBC connection?

UPD: "CONNECT TO ..." and "EXEC SQL CONNECT TO ..." also fail.

The documentation should help you: Connecting to the DB over JDBC — Mick Mnemonic
– Mick Mnemonic, Commented Oct 18, 2017 at 18:21
How could I notice that when you haven't shared any JDBC / Java code? It is also unclear to me what you're attempting to do here. — Mick Mnemonic
– Mick Mnemonic, Commented Oct 18, 2017 at 18:33
Having fresh server and 'postgres' superuser, I want to create another database and schema within this new database staying within the same JDBC connection. I know it is possible to do it using two subsequent JDBC connections. However, it is not the option for me — Alexander Pavlov
– Alexander Pavlov, Commented Oct 18, 2017 at 18:38
Opening a new connection is the only way you can do this. — user330315
– user330315, Commented Oct 18, 2017 at 18:49

Craig Ringer · Accepted Answer · 2017-10-19 04:52:27Z

4

Backslash commands are not PostgreSQL SQL commands, they're commands in the psql command-line utility. Behind the scenes, \connect just closes the connection and opens a new one.

PostgreSQL its self does not have any way to switch databases on a connection.

Disconnect and reconnect to the other DB.

answered Oct 19, 2017 at 4:52

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What is JDBC counterpart of Postgres' "\connect" command?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related