Kotlin connect to Postgres

main.kt

package org.example

import java.sql.DriverManager

fun main() {
    val rows: List<Map<String, Any?>>
    DriverManager.getConnection("jdbc:postgresql://localhost:5432/myapp", "myapp", "password").use { connection ->
        connection.createStatement().use { stmt ->
            stmt.executeQuery("select * from salesforce.account").use { rs ->
                rows = generateSequence {
                    if (rs.next()) {
                        (1..rs.metaData.columnCount).associate { index ->
                            rs.metaData.getColumnName(index) to rs.getObject(index)
                        }
                    } else null
                }.toList()
            }
        }
    }
    rows.forEach { println(it) }
}