jOOQ DSL demo

JooqDslTest.java

package test;

import org.jooq.SQLDialect;
import org.jooq.impl.DSL;
import org.postgresql.ds.PGSimpleDataSource;

import java.sql.Connection;
import java.util.Objects;

public class JooqDslTest {

    public static void main(final String ... args) throws Exception {

        final PGSimpleDataSource ds = new PGSimpleDataSource();
        ds.setDatabaseName(args[1]);

        final Connection connection = ds.getConnection();

        DSL.using(connection, SQLDialect.POSTGRES)
                .meta()
                .getTables()
                .stream()
                .map(t -> t.getPrimaryKey())
                .filter(Objects::nonNull)
                .forEach(System.out::println);

        connection.close();
    }

}

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>test</groupId>
    <artifactId>jooq-test</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>org.jooq</groupId>
            <artifactId>jooq</artifactId>
            <version>3.4.4</version>
        </dependency>
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.3-1102-jdbc41</version>
        </dependency>
    </dependencies>

</project>