---
schema_version: "1"
id: ebc792d76990551772b5e6a10363c9d2fd0ab5e813cfb63324a51a7777ece811
title: Create a Heroku Postgres Client in Java
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/salesforce-functions/functions/guide/dev-guide/heroku-postgres-java.md
canonical_url: https://developer.salesforce.com/docs/platform/functions/guide/heroku-postgres-java.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 538f44b3edd0187786703d58d1b2bc7be1ee8318ef8e283945f89ece3837a727
products:
  - Salesforce Functions
---
# Create a Heroku Postgres Client in Java

For Java, access your Heroku PostgreSQL database and `DATABASE_URL` with environment variable `org.postgresql` using method `System.getenv` to create a Postgres client instance.

```java
private static Connection getConnection()
    throw URISyntaxException, SQLException, ClassNotFoundException {
    Class.forName("org.postgresql.Driver");
    URI dbUri = new URI(System.getenv("DATABASE_URL"));

    String username = dbUri.getUserInfo().split(":")[0]
    String username = dbUri.getUserInfo().split(":")[1]
    String dbUrl = "jdbc:postgresql:''" + dbUri.getHost() + ":" + dbUri.getPort() + dbUri.getPath();

    return DriverManager.getConnection(dbUrl, username, password);
    }
```