命令，用于查看所有现有名称空间和数据库的列表。

Question

我最近遇到了SurrealDB，并安装了它。

添加到path之后，我使用surreal start启动了服务器。

 .d8888b.                                             888 8888888b.  888888b. 
d88P  Y88b                                            888 888  'Y88b 888  '88b
Y88b.                                                 888 888    888 888  .88P
 'Y888b.   888  888 888d888 888d888  .d88b.   8888b.  888 888    888 8888888K.
    'Y88b. 888  888 888P'   888P'   d8P  Y8b     '88b 888 888    888 888  'Y88b
      '888 888  888 888     888     88888888 .d888888 888 888    888 888    888
Y88b  d88P Y88b 888 888     888     Y8b.     888  888 888 888  .d88P 888   d88P
 'Y8888P'   'Y88888 888     888      'Y8888  'Y888888 888 8888888P'  8888888P'


[2022-09-27 14:14:30] INFO  surrealdb::iam Root authentication is disabled
[2022-09-27 14:14:30] INFO  surrealdb::dbs Database strict mode is disabled
[2022-09-27 14:14:30] INFO  surrealdb::kvs Starting kvs store in memory
[2022-09-27 14:14:30] INFO  surrealdb::kvs Started kvs store in memory
[2022-09-27 14:14:30] INFO  surrealdb::net Starting web server on 0.0.0.0:8000
[2022-09-27 14:14:30] INFO  surrealdb::net Started web server on 0.0.0.0:8000

然后，我使用surreal sql --conn http://0.0.0.0:8000在另一个终端中输入数据库。

如何列出所有名称空间和数据库？

另外，当我使用像SELECT * FROM buybig这样的命令时，我得到：

> SELECT * FROM buybig;
There was an error with the remote request: error sending request for url (http://0.0.0.0:8000/sql): error trying to connect: tcp connect error: The requested address is not valid in its context. (os error 10049)   
>

Answer 1

可以使用INFO查询列出名称空间。

INFO FOR KV;

回传

[
    {
        "time": "19.6µs",
        "status": "OK",
        "result": {
            "ns": {
                "namespace1": "DEFINE NAMESPACE namespace1",
                "namespace2": "DEFINE NAMESPACE namespace2"
            }
        }
    }
]

您可以通过使用USE NS选择名称空间并运行INFO FOR NS来检索名称空间中的数据库。

USE NS namespace1;
INFO FOR NS;

这个会回来的

[
    {
        "time": "21.9µs",
        "status": "OK",
        "result": {
            "db": {
                "database1": "DEFINE DATABASE database1",
                "database2": "DEFINE DATABASE database2"
            },
            "nl": {},
            "nt": {}
        }
    }
]