如何在go应用中查看postgresql“提升通知”

import (
    "database/sql"
    _ "github.com/lib/pq"
)

db, err := sql.Open("postgres", "host=your_host port=your_port user=your_user password=your_password dbname=your_db sslmode=disable")
if err != nil {
    // 处理连接错误
}
defer db.Close()

_, err = db.Exec("LISTEN your_channel")
if err != nil {
    // 处理启用通知错误
}

go func() {
    for {
        select {
        case <-ctx.Done():
            return
        case n := <-db.Notify:
            // 处理接收到的通知
            fmt.Println("收到通知:", n.Channel, n.Payload)
        }
    }
}()

_, err = db.Exec("NOTIFY your_channel, '你的通知内容'")
if err != nil {
    // 处理发送通知错误
}