-
Notifications
You must be signed in to change notification settings - Fork 964
Closed
Labels
Description
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 existDatabase 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
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