sql\queries\users.sql:1:1: relation "users" does not exist

[kaliban2056]

Version

1.26.0

What happened?

I encountered this error when I ran the command “sqlc generate”, this is the structure of the sql and yaml files.

Relevant log output

PS C:\Users\%USERNAME%\Documents\project_1> sqlc generate
# package 
sql\queries\users.sql:1:1: relation "users" does not exist

Database schema

-- +goose up

CREATE TABLE users (
     id UUID PRIMARY KEY,
     created_at TIMESTAMP NOT NULL,
     updated_at TIMESTAMP NOT NULL,
     name TEXT NOT NULL
);

-- +goose down

DROP TABLE USERS;

SQL queries

-- name: CreateUser :one
INSERT INTO users (id, created_at, updated_at, name)
VALUES ($1, $2, $3, $4)
RETURNING *;

Configuration

version: "2"
sql:
  - schema: "sql/schema"
    queries: "sql/queries"
    engine: "postgresql"
    gen:
      go:
        out: "internal/database"

Playground URL

No response

What operating system are you using?

Windows

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[stnokott]

Did you try replacing -- +goose up with -- +goose Up (and the same for Down).

That's what the official DDL examples show.

[kaliban2056]

the only thing, I didn't tried, it works, thank you.