information_schema.tables doesn't contain the tables/views from information_schema itself

[krlmlr]

What happens?

Unlike Postgres, the tables and columns views/tables are empty and don't list the schema of information_schema itself.

To Reproduce

$ echo "CREATE TABLE x (a int); SELECT * FROM information_schema.schemata; SELECT DISTINCT table_name FROM information_schema.tables; SELECT DISTINCT table_name FROM information_schema.columns;" | build/debug/duckdb
┌──────────────┬────────────────────┬──────────────┬───────────────────────────────┬──────────────────────────────┬────────────────────────────┬──────────┐
│ catalog_name │    schema_name     │ schema_owner │ default_character_set_catalog │ default_character_set_schema │ default_character_set_name │ sql_path │
├──────────────┼────────────────────┼──────────────┼───────────────────────────────┼──────────────────────────────┼────────────────────────────┼──────────┤
│              │ pg_catalog         │ duckdb       │                               │                              │                            │          │
│              │ information_schema │ duckdb       │                               │                              │                            │          │
│              │ main               │ duckdb       │                               │                              │                            │          │
│              │ temp               │ duckdb       │                               │                              │                            │          │
└──────────────┴────────────────────┴──────────────┴───────────────────────────────┴──────────────────────────────┴────────────────────────────┴──────────┘
┌────────────┐
│ table_name │
├────────────┤
│ x          │
└────────────┘
┌────────────┐
│ table_name │
├────────────┤
│ x          │
└────────────┘

Environment (please complete the following information):

• OS: macOS
• DuckDB Version: cdfb9f9
• DuckDB Client: CLI

Before Submitting

• Have you tried this on the latest master branch?

• Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

[krlmlr]

With Postgres:

$ echo "SELECT COUNT(*) FROM information_schema.columns WHERE lower(table_schema) = 'information_schema';" | psql
 count
-------
   696
(1 row)

[rpbouman]

As a workaround, you can use the duckdb_% table functions.
See:

https://duckdb.org/docs/sql/duckdb_table_functions

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stale for 30 days with no activity.