Swift 3 postgresql

Package.swift

// swift Package.swift

import PackageDescription

let package = Package(
    name: "demo-pgsql",
    dependencies: [
        .Package(url: "https://github.com/PerfectlySoft/Perfect-PostgreSQL.git", majorVersion: 2, minor: 0)
    ]
)

swift_pg_demo.swift

import PostgreSQL
import Core

do {
    let p = PGConnection()
    let status = p.connectdb("host=localhost dbname=swift_test")
    print("status is \(status)\n")

    let result = p.exec(
        statement: " select name from test1 ")

    let num = result.numTuples()
    print("num is \(num)\n")

    for x in 0..<num {
        // let c1 = res.getFieldString(tupleIndex: x, fieldIndex: 0
        let name = result.getFieldString(tupleIndex: x, fieldIndex: 0)!
        print("name is \(name)\n")
    }

    defer {
        result.clear()
        p.close() // close the connection
    }
} catch {
    print("\(error)\n")
}