Version
Other
What happened?
I'm trying to generate a function from a query like this:
-- name: GetMyTableColumns :many
SELECT column_name,
data_type
FROM information_schema.columns
WHERE table_name = 'my_table';
but I get the following error while generating:
schema "information_schema" does not exist
Relevant log output
schema "information_schema" does not exist
Database schema
information_schema,
but in the sqlc.yaml I am using `schema: "migrations"` because I'm using `"github.com/golang-migrate/migrate/v4"`
SQL queries
-- name: GetMyTableColumns :one
SELECT column_name,
data_type
FROM information_schema.columns
WHERE table_name = 'my_table';
Configuration
Playground URL
No response
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
Version
Other
What happened?
I'm trying to generate a function from a query like this:
but I get the following error while generating:
schema "information_schema" does not existRelevant log output
schema "information_schema" does not existDatabase schema
SQL queries
Configuration
see abovePlayground URL
No response
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go