2023-01-10 LightDB访问数据库.md

炮姐的呱太

已于 2024-04-17 15:46:59 修改

阅读量116

点赞数

分类专栏： LightDB 文章标签：数据库

于 2023-06-21 10:21:50 首次发布

本文链接：https://blog.csdn.net/richar1/article/details/131331504

版权

LightDB 专栏收录该内容

9 篇文章 2 订阅

订阅专栏

LightDB-访问数据库

访问数据库

[lightdb@localhost ~]$ ltsql mydb
ltsql (13.8-22.3)
Type "help" for help.

lightdb@mydb=#

输入几条指令

lightdb@mydb=# select version();
                                                  version                                                  
-----------------------------------------------------------------------------------------------------------
 LightDB 13.8-22.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)

lightdb@mydb=# select current_date;
 current_date 
--------------
 2023-01-09
(1 row)

lightdb@mydb=# select 2+2;
 ?column? 
----------
        4
(1 row)

ltsql内部指令以""开头，例如

#指令帮助列表
lightdb@mydb=# \h
Available help:
  ABORT                            CLOSE                            CREATE VIEW                      DROP USER MAPPING
  ALTER AGGREGATE                  CLUSTER                          DEALLOCATE                       DROP VIEW
  ALTER COLLATION                  COMMENT                          DECLARE                          END
  ALTER CONVERSION                 COMMIT                           DELETE                           EXECUTE
  ALTER DATABASE                   COMMIT PREPARED                  DISCARD                          EXPLAIN
 .... 

#输入具体想要了解的指令
lightdb@mydb=# \h ALTER DATABASE
Command:     ALTER DATABASE
Description: change a database
Syntax:
ALTER DATABASE name [ [ WITH ] option [ ... ] ]

where option can be:

    ALLOW_CONNECTIONS allowconn
    CONNECTION LIMIT connlimit
    IS_TEMPLATE istemplate

ALTER DATABASE name RENAME TO new_name

ALTER DATABASE name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }

ALTER DATABASE name SET TABLESPACE new_tablespace

ALTER DATABASE name SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER DATABASE name SET configuration_parameter FROM CURRENT
ALTER DATABASE name RESET configuration_parameter
ALTER DATABASE name RESET ALL

URL: https://www.postgresql.org/docs/13/sql-alterdatabase.html

退出ltsql