PostgreSQL JDBC URL with database name containing forward slash

Question

I have a database named sales/pre in postgreSQL. While connecting to this database with JDBC application, the characters after forward slash get omitted, and I get the following error:

FATAL: database "sales" does not exist.

Is there a way to escape the forward slash?

samlewis · Accepted Answer · 2016-07-16 20:20:22Z

2

You are using a JDBC URL so you need to url encode your forward slash e.g.

jdbc:postgresql://host:port/sales%2Fpre

Alternatively choose a different database name.

answered Jul 16, 2016 at 20:20

samlewis

4,05830 silver badges27 bronze badges

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

2 Comments

Mark Rotteveel Over a year ago

Not all JDBC drivers use URL encoding (and the JDBC standard doesn't actually say anything about it), so it might work for PostgreSQL (I don't know), but that doesn't mean it works for all JDBC drivers.

Pradeep Prasath Over a year ago

@MarkRotteveel is correct, I t doesn't encode forward slash, I get same error saying FATAL: database sales%2Fpre does not exist

Collectives™ on Stack Overflow

PostgreSQL JDBC URL with database name containing forward slash

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest