Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgresqldb

package

Go to main page

Versions in this module

v0

v0.12.0

Jun 11, 2026

v0.11.0

Jun 11, 2026

Changes in this version

+ type AddTagToPostParams struct

+ PostId *uuid.UUID

+ PostId2 *uuid.UUID

+ type CreateCommentParams struct

+ PostId *uuid.UUID

+ PostId2 *uuid.UUID

+ PostId3 pgtype.Text

+ type CreatePostParams struct

+ UserId *uuid.UUID

+ UserId2 pgtype.Text

+ UserId3 pgtype.Text

+ UserId4 pgtype.Text

+ UserId5 pgtype.Bool

+ UserId6 *time.Time

+ type CreateTagParams struct

+ Tagname pgtype.Text

+ Tagname2 pgtype.Text

+ type CreateUserParams struct

+ Username pgtype.Text

+ Username2 pgtype.Text

+ Username3 *[]byte

+ Username4 pgtype.Text

type Querier

+ WithTx func(tx DBTX) *Queries

type Queries

+ func (q *Queries) WithTx(tx DBTX) *Queries

+ type RemoveTagFromPostParams struct

+ PostId *uuid.UUID

+ TagId *uuid.UUID

+ type UpdateCommentParams struct

+ Commentbody pgtype.Text

+ Id uuid.UUID

+ type UpdatePostParams struct

+ Categories pgtype.Text

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt any

+ Title pgtype.Text

+ type UpdateTagParams struct

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type UpdateUserParams struct

+ Id uuid.UUID

+ Metadata *[]byte

+ Tags pgtype.Text

+ Useremail pgtype.Text

+ Username pgtype.Text

v0.5.0

Feb 9, 2026

v0.3.0

Feb 7, 2026

Changes in this version

+ type Comments struct

+ Commentbody pgtype.Text

+ CreatedAt pgtype.Timestamptz

+ Id uuid.UUID

+ Likes pgtype.Int4

+ PostId *uuid.UUID

+ UserId *uuid.UUID

+ type CreateCommentRow struct

+ Commentbody pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Likes pgtype.Int4

+ PostId *uuid.UUID

+ UserId *uuid.UUID

+ type CreatePostRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type CreateTagRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type CreateUserRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type DBTX interface

+ ExecContext func(ctx context.Context, query string, args ...any) (sql.Result, error)

+ QueryContext func(ctx context.Context, query string, args ...any) (*sql.Rows, error)

+ QueryRowContext func(ctx context.Context, query string, args ...any) *sql.Row

+ type GetCommentByIdRow struct

+ Commentbody pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Likes pgtype.Int4

+ PostId *uuid.UUID

+ UserId *uuid.UUID

+ type GetPopularPostsRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type GetPostByIdRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type GetPostsForTagRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type GetTagByIdRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type GetTagByNameRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type GetTagsForPostRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type GetUserByEmailRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type GetUserByIdRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type GetUserStatsRow struct

+ CommentCount int64

+ Id uuid.UUID

+ PostCount int64

+ TotalViews pgtype.Int4

+ Username pgtype.Text

+ type ListActiveUsersRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type ListCommentsByPostRow struct

+ Commentbody pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Likes pgtype.Int4

+ PostId *uuid.UUID

+ UserId *uuid.UUID

+ type ListCommentsByUserRow struct

+ Commentbody pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Likes pgtype.Int4

+ PostId *uuid.UUID

+ UserId *uuid.UUID

+ type ListPostsByUserRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type ListPostsRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type ListPublishedPostsRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type ListTagsRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type ListUsersRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type Posts struct

+ Categories pgtype.Text

+ CreatedAt pgtype.Timestamptz

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt pgtype.Timestamptz

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt pgtype.Timestamptz

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type Querier interface

+ AddTagToPost func(ctx context.Context, arg1 *uuid.UUID, arg2 *uuid.UUID) (sql.Result, error)

+ CreateComment func(ctx context.Context, arg1 *uuid.UUID, arg2 *uuid.UUID, arg3 pgtype.Text) (CreateCommentRow, error)

+ CreatePost func(ctx context.Context, arg1 *uuid.UUID, arg2 pgtype.Text, arg3 pgtype.Text, ...) (CreatePostRow, error)

+ CreateTag func(ctx context.Context, arg1 pgtype.Text, arg2 pgtype.Text) (CreateTagRow, error)

+ CreateUser func(ctx context.Context, arg1 pgtype.Text, arg2 pgtype.Text, arg3 *[]byte, ...) (CreateUserRow, error)

+ DeleteComment func(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ DeletePost func(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ DeleteTag func(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ DeleteUser func(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ GetCommentById func(ctx context.Context, arg1 uuid.UUID) (GetCommentByIdRow, error)

+ GetPopularPosts func(ctx context.Context, arg1 pgtype.Int4) ([]GetPopularPostsRow, error)

+ GetPostById func(ctx context.Context, arg1 uuid.UUID) (GetPostByIdRow, error)

+ GetPostsForTag func(ctx context.Context, arg1 *uuid.UUID) ([]GetPostsForTagRow, error)

+ GetTagById func(ctx context.Context, arg1 uuid.UUID) (GetTagByIdRow, error)

+ GetTagByName func(ctx context.Context, arg1 pgtype.Text) (GetTagByNameRow, error)

+ GetTagsForPost func(ctx context.Context, arg1 *uuid.UUID) ([]GetTagsForPostRow, error)

+ GetUserByEmail func(ctx context.Context, arg1 pgtype.Text) (GetUserByEmailRow, error)

+ GetUserById func(ctx context.Context, arg1 uuid.UUID) (GetUserByIdRow, error)

+ GetUserStats func(ctx context.Context, arg1 uuid.UUID) (GetUserStatsRow, error)

+ IncrementPostViews func(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ LikeComment func(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ ListActiveUsers func(ctx context.Context) ([]ListActiveUsersRow, error)

+ ListCommentsByPost func(ctx context.Context, arg1 *uuid.UUID) ([]ListCommentsByPostRow, error)

+ ListCommentsByUser func(ctx context.Context, arg1 *uuid.UUID) ([]ListCommentsByUserRow, error)

+ ListPosts func(ctx context.Context) ([]ListPostsRow, error)

+ ListPostsByUser func(ctx context.Context, arg1 *uuid.UUID) ([]ListPostsByUserRow, error)

+ ListPublishedPosts func(ctx context.Context) ([]ListPublishedPostsRow, error)

+ ListTags func(ctx context.Context) ([]ListTagsRow, error)

+ ListUsers func(ctx context.Context) ([]ListUsersRow, error)

+ RemoveTagFromPost func(ctx context.Context, arg1 *uuid.UUID, arg2 *uuid.UUID) (sql.Result, error)

+ SearchPostsByCategory func(ctx context.Context, arg1 pgtype.Int4) ([]SearchPostsByCategoryRow, error)

+ SearchUsersByMetadata func(ctx context.Context, arg1 pgtype.Int4) ([]SearchUsersByMetadataRow, error)

+ SearchUsersByTag func(ctx context.Context, arg1 pgtype.Int4) ([]SearchUsersByTagRow, error)

+ UpdateComment func(ctx context.Context, arg2 pgtype.Text, arg1 uuid.UUID) (UpdateCommentRow, error)

+ UpdatePost func(ctx context.Context, arg2 pgtype.Text, arg3 pgtype.Text, arg4 pgtype.Text, ...) (UpdatePostRow, error)

+ UpdateTag func(ctx context.Context, arg2 pgtype.Text, arg3 pgtype.Text, arg1 uuid.UUID) (UpdateTagRow, error)

+ UpdateUser func(ctx context.Context, arg2 pgtype.Text, arg3 pgtype.Text, arg4 *[]byte, ...) (UpdateUserRow, error)

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) AddTagToPost(ctx context.Context, arg1 *uuid.UUID, arg2 *uuid.UUID) (sql.Result, error)

+ func (q *Queries) CreateComment(ctx context.Context, arg1 *uuid.UUID, arg2 *uuid.UUID, arg3 pgtype.Text) (CreateCommentRow, error)

+ func (q *Queries) CreatePost(ctx context.Context, arg1 *uuid.UUID, arg2 pgtype.Text, arg3 pgtype.Text, ...) (CreatePostRow, error)

+ func (q *Queries) CreateTag(ctx context.Context, arg1 pgtype.Text, arg2 pgtype.Text) (CreateTagRow, error)

+ func (q *Queries) CreateUser(ctx context.Context, arg1 pgtype.Text, arg2 pgtype.Text, arg3 *[]byte, ...) (CreateUserRow, error)

+ func (q *Queries) DeleteComment(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ func (q *Queries) DeletePost(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ func (q *Queries) DeleteTag(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ func (q *Queries) DeleteUser(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ func (q *Queries) GetCommentById(ctx context.Context, arg1 uuid.UUID) (GetCommentByIdRow, error)

+ func (q *Queries) GetPopularPosts(ctx context.Context, arg1 pgtype.Int4) ([]GetPopularPostsRow, error)

+ func (q *Queries) GetPostById(ctx context.Context, arg1 uuid.UUID) (GetPostByIdRow, error)

+ func (q *Queries) GetPostsForTag(ctx context.Context, arg1 *uuid.UUID) ([]GetPostsForTagRow, error)

+ func (q *Queries) GetTagById(ctx context.Context, arg1 uuid.UUID) (GetTagByIdRow, error)

+ func (q *Queries) GetTagByName(ctx context.Context, arg1 pgtype.Text) (GetTagByNameRow, error)

+ func (q *Queries) GetTagsForPost(ctx context.Context, arg1 *uuid.UUID) ([]GetTagsForPostRow, error)

+ func (q *Queries) GetUserByEmail(ctx context.Context, arg1 pgtype.Text) (GetUserByEmailRow, error)

+ func (q *Queries) GetUserById(ctx context.Context, arg1 uuid.UUID) (GetUserByIdRow, error)

+ func (q *Queries) GetUserStats(ctx context.Context, arg1 uuid.UUID) (GetUserStatsRow, error)

+ func (q *Queries) IncrementPostViews(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ func (q *Queries) LikeComment(ctx context.Context, arg1 uuid.UUID) (sql.Result, error)

+ func (q *Queries) ListActiveUsers(ctx context.Context) ([]ListActiveUsersRow, error)

+ func (q *Queries) ListCommentsByPost(ctx context.Context, arg1 *uuid.UUID) ([]ListCommentsByPostRow, error)

+ func (q *Queries) ListCommentsByUser(ctx context.Context, arg1 *uuid.UUID) ([]ListCommentsByUserRow, error)

+ func (q *Queries) ListPosts(ctx context.Context) ([]ListPostsRow, error)

+ func (q *Queries) ListPostsByUser(ctx context.Context, arg1 *uuid.UUID) ([]ListPostsByUserRow, error)

+ func (q *Queries) ListPublishedPosts(ctx context.Context) ([]ListPublishedPostsRow, error)

+ func (q *Queries) ListTags(ctx context.Context) ([]ListTagsRow, error)

+ func (q *Queries) ListUsers(ctx context.Context) ([]ListUsersRow, error)

+ func (q *Queries) RemoveTagFromPost(ctx context.Context, arg1 *uuid.UUID, arg2 *uuid.UUID) (sql.Result, error)

+ func (q *Queries) SearchPostsByCategory(ctx context.Context, arg1 pgtype.Int4) ([]SearchPostsByCategoryRow, error)

+ func (q *Queries) SearchUsersByMetadata(ctx context.Context, arg1 pgtype.Int4) ([]SearchUsersByMetadataRow, error)

+ func (q *Queries) SearchUsersByTag(ctx context.Context, arg1 pgtype.Int4) ([]SearchUsersByTagRow, error)

+ func (q *Queries) UpdateComment(ctx context.Context, arg2 pgtype.Text, arg1 uuid.UUID) (UpdateCommentRow, error)

+ func (q *Queries) UpdatePost(ctx context.Context, arg2 pgtype.Text, arg3 pgtype.Text, arg4 pgtype.Text, ...) (UpdatePostRow, error)

+ func (q *Queries) UpdateTag(ctx context.Context, arg2 pgtype.Text, arg3 pgtype.Text, arg1 uuid.UUID) (UpdateTagRow, error)

+ func (q *Queries) UpdateUser(ctx context.Context, arg2 pgtype.Text, arg3 pgtype.Text, arg4 *[]byte, ...) (UpdateUserRow, error)

+ type QueryResult struct

+ LastInsertID int64

+ RowsAffected int64

+ type SearchPostsByCategoryRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type SearchUsersByMetadataRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type SearchUsersByTagRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type Tags struct

+ CreatedAt pgtype.Timestamptz

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type UpdateCommentRow struct

+ Commentbody pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Likes pgtype.Int4

+ PostId *uuid.UUID

+ UserId *uuid.UUID

+ type UpdatePostRow struct

+ Categories pgtype.Text

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsPublished pgtype.Bool

+ Postbody pgtype.Text

+ PublishedAt *time.Time

+ Rating *decimal.Decimal

+ Title pgtype.Text

+ UpdatedAt *time.Time

+ UserId *uuid.UUID

+ ViewCount pgtype.Int4

+ type UpdateTagRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ Tagdescription pgtype.Text

+ Tagname pgtype.Text

+ type UpdateUserRow struct

+ CreatedAt *time.Time

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt *time.Time

+ Useremail pgtype.Text

+ Username pgtype.Text

+ type Users struct

+ CreatedAt pgtype.Timestamptz

+ Id uuid.UUID

+ IsActive pgtype.Bool

+ Metadata *[]byte

+ Tags pgtype.Text

+ UpdatedAt pgtype.Timestamptz

+ Useremail pgtype.Text

+ Username pgtype.Text