Parsing the query result into a map

Sometimes the result of the query or the structure of the table is not clear, and the result needs to be extracted to some flexible structure. This brings us to this recipe, where the extraction of values mapped to column names will be presented.

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