Pg: Logger or output of raw SQL generated

[owentran]

I've started migrating my project from beego ORM to use pg.v2. So far, it's been fantastic and handles some of few PostgreSQL issues I've had like UUID and Array support. Is there a way to output the raw generated SQL?

[vmihailenco]

No, but in development environment you can adjust PostgreSQL to log all queries:

log_statement = 'all'
log_min_duration_statement = 0

Then postgresql-9.4-main.log will contain generated SQL. Is it enough for your needs?

[owentran]

That works for now. Thanks.

[alikhil]

As it mentioned in wiki it also can be done this way:

type dbLogger struct { }

func (d dbLogger) BeforeQuery(c context.Context, q *pg.QueryEvent) (context.Context, error) {
    return c, nil
}

func (d dbLogger) AfterQuery(c context.Context, q *pg.QueryEvent) error {
    fmt.Println(q.FormattedQuery())
    return nil
}

db := pg.Connect(&pg.Options{...})
db.AddQueryHook(dbLogger{})

[PhillyWebGuy]

When I try that, I get this:
cannot use dbLogger literal (type dbLogger) as type pg.QueryHook in argument to db.baseDB.AddQueryHook: dbLogger does not implement pg.QueryHook (wrong type for AfterQuery method) have AfterQuery(context.Context, *pg.QueryEvent) error want AfterQuery(*pg.QueryEvent)

[PhillyWebGuy]

This seems to work when trying to AfterQuery method. I haven't worked out the BeforeQuery method yet:

`type dbLogger struct{}

func (d dbLogger) AfterQuery(q *pg.QueryEvent) {
fmt.Println(q.FormattedQuery())
return
}

db := pg.Connect(&pg.Options{...})
db.AddQueryHook(dbLogger{})`

[craigtracey]

@PhillyWebGuy you likely have an incorrect import. Make sure you have imported:

"github.com/go-pg/pg/v10"
not
"github.com/go-pg/pg"