Is it possible to see the raw SQL statements?

[lukehinds]

I am seeing sql: no rows in result set for a quite simple statement that works when I run it on psql CLI.

Is there anyway of printing out what raw SQL is executed , so I can just check formatting etc?

[kyleconroy]

The raw query is available in the generated code. That should show you exact what query is being run.

[Jille]

If you're using pgx, I use this to log all the queries:

  cc, err := pgxpool.ParseConfig(config.GetDSN())
  if err != nil {
    log.Fatalf("Failed to connect to database: %v", err)
  }
  if *queryLogging {
    cc.ConnConfig.Logger = logrusadapter.NewLogger(&logrus.Logger{
      Out:          os.Stderr,
      Formatter:    new(logrus.JSONFormatter),
      Hooks:        make(logrus.LevelHooks),
      Level:        logrus.InfoLevel,
      ExitFunc:     os.Exit,
      ReportCaller: false,
    })
  }

If you don't use pgx, you could relatively easily intercept the queries as they're being sent to the database by implementing a DBTX that logs and then sends them on to the database.

[ptman]

In pgx/v5 it's ConnConfig.Tracer and tracelog.