列出OpenBSD数据库/sqlports sqlite3数据库的表和字段 [英] list tables and fields of OpenBSD databases/sqlports sqlite3 database

问题描述

如何开始使用sqlite3数据库?

例如，有 http://openports.se/databases/sqlports ，其中包含有关OpenBSD端口；我已将其安装在OpenBSD 5.2上，并且根据/var/db/pkg/sqlports-2.3p0/+CONTENTS创建的唯一文件是/usr/local中的share/sqlports.

For example, there's http://openports.se/databases/sqlports that contains various info about OpenBSD ports; I've installed it on OpenBSD 5.2, and the only file it created, as per /var/db/pkg/sqlports-2.3p0/+CONTENTS, is share/sqlports in /usr/local.

% file /usr/local/share/sqlports
/usr/local/share/sqlports: SQLite 3.x database

我如何知道它具有哪些表以及每个表具有哪些字段?

How do I know which tables it has, and what fields does each table has?

推荐答案

cnst，您的答案是正确的.您也可以使用.命令. 例如列出您输入.databases的数据库并获取表.tables

cnst your answer is right. You can also use the . commands . for example to list the databases you enter .databases and to get the tables .tables

尝试.help以获得更多可能的命令.

Try .help for more possible commands.

对于OpenBSD pkg信息，您可以在文件系统友好格式下的目录下找到它们. /var/db/pkg/

As for OpenBSD pkg info you can find them in a filesystem friendly format, in directories under /var/db/pkg/

这篇关于列出OpenBSD数据库/sqlports sqlite3数据库的表和字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！