5 lines
459 B
Bash
5 lines
459 B
Bash
|
set -u
|
||
|
|
echo "=== dsh_instances 列 ==="
|
||
|
|
sudo -u postgres psql -p 15432 -d dshs -Atc "select column_name from information_schema.columns where table_name='dsh_instances' order by ordinal_position" 2>&1 | grep -v 'could not change' | tr '\n' ' '; echo
|
||
|
|
echo "=== 归属 ==="
|
||
|
|
sudo -u postgres psql -p 15432 -d dshs -Atc "select u.username, i.host_id, i.status from users u left join dsh_instances i on i.user_id=u.id order by 1" 2>&1 | grep -v 'could not change'
|