show tables in
时间: 2023-07-13 09:33:07 浏览: 120
"show tables in" 是用于查看特定数据库中所有表的命令。在SQL中,可以使用以下方式来使用 "show tables in" 命令:
```
show tables in mydatabase;
```
该命令将返回名为 "mydatabase" 的数据库中所有表的列表。可以将 "in" 替换为 "from",两者效果是一样的。
相关问题
#!/bin/bash # 连接hive beeline -u jdbc:hive2://localhost:10000 -n username -p password -e "set hive.cli.print.header=false; set hive.resultset.use.unique.column.names=true; set hive.cli.print.current.db=false;" # 统计表数据量 tables=$(beeline -u jdbc:hive2://localhost:10000 -n username -p password -e "show tables in yinzhou like 'db_*';" | grep -v "INFO" | grep -v "WARN") # 输出cvs文件 echo "Table Name,Data Size" > db_tables.csv while read -r table; do data_size=$(beeline -u jdbc:hive2://localhost:10000 -n username -p password -e "select count(*) from yinzhou.$table;") echo "$table,$data_size" >> db_tables.csv done <<< "$tables"
看起来您的代码格式有点混乱,可能是因为复制粘贴时出现了问题。请尝试使用以下代码,并将其中的username和password替换为您的用户名和密码:
```bash
#!/bin/bash
# 连接hive
beeline -u jdbc:hive2://localhost:10000 -n username -p password -e "set hive.cli.print.header=false; set hive.resultset.use.unique.column.names=true; set hive.cli.print.current.db=false;"
# 统计表数据量
tables=$(beeline -u jdbc:hive2://localhost:10000 -n username -p password -e "show tables in yinzhou like 'db_*';" | grep -v "INFO" | grep -v "WARN")
# 输出cvs文件
echo "Table Name,Data Size" > db_tables.csv
while read -r table; do
data_size=$(beeline -u jdbc:hive2://localhost:10000 -n username -p password -e "select count(*) from yinzhou.$table;")
echo "$table,$data_size" >> db_tables.csv
done <<< "$tables"
```
这个脚本会通过beeline连接到hive,并设置输出格式。然后,它会统计yinzhou库下表名开头为db_的表的数据量,并输出到一个cvs文件中。请替换其中的username和password为您的用户名和密码,然后再次尝试运行。
postgresql show tables
To show all tables in a PostgreSQL database, you can use the following SQL command:
```
SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE';
```
This command will retrieve the names of all tables in the "public" schema of your PostgreSQL database. If you have tables in other schemas, you can modify the query to include them as well.
Alternatively, you can use the following command:
```
\dt
```
This is a command used in the psql command-line interface to show all tables in the current database.
阅读全文