Skip to content

Use PostgreSQL system views in queries #2242

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
Davincible opened this issue Apr 28, 2023 · 1 comment
Closed

Use PostgreSQL system views in queries #2242

Davincible opened this issue Apr 28, 2023 · 1 comment
Labels
📚 postgresql 💻 linux enhancement New feature or request 🔧 golang

Comments

@Davincible
Copy link

Davincible commented Apr 28, 2023 •
edited
Loading

Version

1.17.2

What happened?

Can't select from internal tables, gives table doesn't exist

SELECT
      reltuples::BIGINT AS row_count
    FROM
      pg_class
    WHERE
      relname = 'users'

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

No response

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go
@Davincible Davincible added bug Something isn't working triage New issues that hasn't been reviewed labels Apr 28, 2023
@kyleconroy kyleconroy added 📚 postgresql 🔧 golang 💻 linux enhancement New feature or request and removed bug Something isn't working triage New issues that hasn't been reviewed labels Jun 6, 2023
@kyleconroy kyleconroy changed the title select from internal tables Use PostgreSQL system views in queries Jun 6, 2023
@kyleconroy
Copy link
Collaborator

Marking as duplicate of #1171

@kyleconroy kyleconroy closed this as not planned Won't fix, can't repro, duplicate, stale Sep 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
📚 postgresql 💻 linux enhancement New feature or request 🔧 golang
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kyleconroy @Davincible