René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc not accepting go type overrides for timestamp with timezone on postgres","articleBody":"### Version\n\n1.28.0\n\n### What happened?\n\nSqlc doesn't generate models based on the type overrides found in the configuration `sqlc.yaml`. It doesn't accept the go type override for time.Time when the postgres type in the schema is a `timestamp with time zone`, but accepts it when the postgres type is defined using the short hand `timestamptz`.\n\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\n-- doesn't work for this table as the generated model has a created_at pgtype.Timestamptz field\nCREATE TABLE test (\n  id serial,\n  created_at timestamp with time zone not null\n);\n-- works for this table as the generated model has a created_at time.Time field\nCREATE TABLE test2 (\n  id serial,\n  created_at timestamptz not null \n);\n```\n\n### SQL queries\n\n```sql\n\n```\n\n### Configuration\n\n```yaml\nversion: \"2\"\nsql:\n  - engine: \"postgresql\"\n    schema: \"./database/schema.sql\"\n    queries: \"./database/query\"\n    gen:\n      go:\n        emit_json_tags: true\n        package: \"bloc\"\n        out: \"database/sqlc/bloc\"\n        sql_package: \"pgx/v5\"\n        overrides:\n          # Override PostgreSQL \"timestamptz\" to Go's time.Time\n          # Doesn't work if the `db_type` is replaced with timestamp with time zone either\n          - db_type: \"timestamptz\"\n            go_type: \"time.Time\"\n```\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/2b3c34a2cbb6b39c97097dd41b5dba87ac45eeeae192be8e0e40e225405d6527\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/Kerod-Fresenbet-Gebremedhin2660","@type":"Person","name":"Kerod-Fresenbet-Gebremedhin2660"},"datePublished":"2025-02-01T07:58:16.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3815/sqlc/issues/3815"}