如何在go中使用postgres间隔？

package main

import (
    "database/sql"
    "fmt"
    "time"

    _ "github.com/lib/pq"
)

func main() {
    // 连接到PostgreSQL数据库
    db, err := sql.Open("postgres", "host=localhost port=5432 user=your_user password=your_password dbname=your_db sslmode=disable")
    if err != nil {
        fmt.Println("连接数据库失败:", err)
        return
    }
    defer db.Close()

    // 设置查询间隔
    interval := 5 * time.Second

    // 创建一个定时器
    ticker := time.NewTicker(interval)

    // 循环执行查询
    for range ticker.C {
        // 执行查询语句
        rows, err := db.Query("SELECT * FROM your_table")
        if err != nil {
            fmt.Println("查询失败:", err)
            continue
        }

        // 处理查询结果
        for rows.Next() {
            var id int
            var name string
            err := rows.Scan(&id, &name)
            if err != nil {
                fmt.Println("扫描结果失败:", err)
                continue
            }
            fmt.Println("ID:", id, "Name:", name)
        }

        // 关闭查询结果
        rows.Close()
    }
}