Executing statements

In previous recipes, we have gone through how to connect and validate the connection to the database. This recipe will describe how to execute statements against the database.

Getting ready

Verify if Go is properly installed by calling the go version command in your Terminal. If the command fails, follow the Getting ready section in the first recipe of this chapter. 

Set up the PostgreSQL server, as mentioned in the first recipe of this chapter.

How to do it...

1. Run the following SQL script against your sample database:

        DROP TABLE IF EXISTS post;
        CREATE TABLE post (
          ID serial,
          TITLE varchar(40),
          CONTENT varchar(255),
          CONSTRAINT pk_post PRIMARY KEY(ID)
        );
        SELECT * FROM post;

2. Open the console and create the folder chapter08/recipe03.
3. Navigate to the directory.
4. Create the statement.go file with the following content:

        package main

        import (
          "database/sql"
          "fmt"
          _ "github...