-
Notifications
You must be signed in to change notification settings - Fork 375
Open
Description
In sqlite, \dt is intended to list only user-created tables, but it also includes system tables.
Steps to produce
1. prepare a test.db
Create a test.sql file
create table test (test_id int, name string);
insert into test (test_id, name) values (1, 'hello');Execute the sql file
usql sqlite3://test.db -f test.sql
2. run \dt on the test.db
$ usql sqlite3://test.db -c '\dt'
List of relations
Schema | Name | Type
--------+--------------------+--------------
| fts3 | SYSTEM TABLE
| fts3tokenize | SYSTEM TABLE
| fts4 | SYSTEM TABLE
| fts4aux | SYSTEM TABLE
| fts5 | SYSTEM TABLE
| fts5vocab | SYSTEM TABLE
| json_each | SYSTEM TABLE
| json_tree | SYSTEM TABLE
| pragma_module_list | SYSTEM TABLE
| rtree | SYSTEM TABLE
| rtree_i32 | SYSTEM TABLE
| test | TABLE
(12 rows)
Additional Context
$ usql --version
usql 0.19.14
Metadata
Metadata
Assignees
Labels
No labels