gistfile1.dart

import 'dart:async';

import 'package:postgresql/postgresql.dart';

void main() {
  var username = "TheRightMan";
  var password = "WithTheRightSecret";
  var DBname = "AtTheRightPlace";  
  var uri = 'postgres://$username:$password@localhost:5432/$DBname';
  
  //Opens a connection.
  connect(uri)
    .then((Connection connection) =>
        insertPerson(connection, "Thomas", "Pedersen", new DateTime(1990, 01, 1), 1.92))
    .then((connection) =>
        printEntireTable(connection))
    .then((connection) =>
        connection.close());
}

Future insertPerson(Connection connection, 
                    String firstname, String lastname, 
                    DateTime dateOfBirth, double height) {
  final String query = 
      "INSERT INTO person (firstname, lastname, dateofbirth, height) VALUES" + 
      "('$firstname', '$lastname', '$dateOfBirth', $height);";
  return connection.execute(query).then((rowsAffected) {
    print("Rows Affected: $rowsAffected");
  });
}

Future printEntireTable(Connection connection) {
  final String query = "SELECT id, firstname, lastname, dateofbirth, height FROM person";
  return connection.query(query).listen((row) {
    var age = ((new DateTime.now()).difference(row.dateofbirth).inDays/365.2425).floor();
    print("(${row.id}) ${row.firstname} ${row.lastname} - $age years old - ${row.height}m");
  }).asFuture();
}