Go Standard Library Cookbook

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;       INSERT INTO post(ID,TITLE,CONTENT) VALUES                       (1,'Title One','Content One'),                       (2,NULL,'Content Two');

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

        package main        import (          "database/sql"          "fmt"          _ "github.com/lib/pq"        )        const sel = `SELECT title,content FROM post;        SELECT 1234 NUM; `         const selOne = "SELECT title,content FROM post                        WHERE ID = $1;"        type Post struct {          Name sql.NullString          Text sql.NullString        }        func main() { db := ...