文章目录
查看所有数据库 ltsql -l
zhangliang[lightdb@localhost ~]$ ltsql -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+----------+------------+------------+---------------------
lt_test | lightdb | UTF8 | en_US.utf8 | en_US.utf8 |
postgres | lightdb | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | lightdb | UTF8 | en_US.utf8 | en_US.utf8 | =c/lightdb +
| | | | | lightdb=CTc/lightdb
template1 | lightdb | UTF8 | en_US.utf8 | en_US.utf8 | =c/lightdb +
| | | | | lightdb=CTc/lightdb
查看所有数据库 \l
lightdb@lt_test-# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+----------+------------+------------+---------------------
lt_test | lightdb | UTF8 | en_US.utf8 | en_US.utf8 |
postgres | lightdb | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | lightdb | UTF8 | en_US.utf8 | en_US.utf8 | =c/lightdb +
| | | | | lightdb=CTc/lightdb
template1 | lightdb | UTF8 | en_US.utf8 | en_US.utf8 | =c/lightdb +
| | | | | lightdb=CTc/lightdb
(4 rows)
连接进入数据库交互 ltsql 数据库
zhangliang[lightdb@localhost ~]$ ltsql lt_test
ltsql (13.8-22.3)
Type "help" for help.
lightdb@lt_test=#
打印交互buffer中的数据 \p
lightdb@lt_test=# select
lightdb@lt_test-# 1 + 3
lightdb@lt_test-# \p
select
1 + 3
lightdb@lt_test-#
清空交互buffer中的数据 \r
lightdb@lt_test=# select
lightdb@lt_test-# 1 + 3
lightdb@lt_test-# \p
select
1 + 3
lightdb@lt_test-# \r
Query buffer reset (cleared).
lightdb@lt_test=# \p
Query buffer is empty.
lightdb@lt_test=#
lightdb@lt_test=# \q
lightdb@lt_test=# \q
zhangliang[lightdb@localhost ~]$
查看表信息 \d
lightdb@lt_test=# CREATE TABLE friend (
lightdb@lt_test(# firstname CHAR(15),
lightdb@lt_test(# lastname CHAR(20),
lightdb@lt_test(# city CHAR(15),
lightdb@lt_test(# state CHAR(2),
lightdb@lt_test(# age INTEGER
lightdb@lt_test(# );
CREATE TABLE
lightdb@lt_test-# \d friend
Table "public.friend"
Column | Type | Collation | Nullable | Default
-----------+---------------+-----------+----------+---------
firstname | character(15) | | |
lastname | character(20) | | |
city | character(15) | | |
state | character(2) | | |
age | integer | | |
拓展显示 \x
列显示结果集
lightdb@lt_test=# select * from friend;
firstname | lastname | city | state | age
-----------------+----------------------+-----------------+-------+-----
zhang | san | hangzhou | 0 | 18
li | si | hangzhou | 1 | 19
(2 rows)
lightdb@lt_test=#
lightdb@lt_test=#
lightdb@lt_test=#
lightdb@lt_test=#
lightdb@lt_test=#
lightdb@lt_test=# \x
Expanded display is on.
lightdb@lt_test=# select * from friend;
-[ RECORD 1 ]-------------------
firstname | zhang
lastname | san
city | hangzhou
state | 0
age | 18
-[ RECORD 2 ]-------------------
firstname | li
lastname | si
city | hangzhou
state | 1
age | 19