#列出所有数据库
postgres-# \l
                                   List of databases
    Name    |   Owner    | Encoding |   Collate   |    Ctype    |   Access privileges   
------------+------------+----------+-------------+-------------+-----------------------
 breeze2020 | vericant   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 moodle     | moodleuser | UTF8     | cs_CZ.utf8  | cs_CZ.utf8  | 
 postgres   | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0  | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
            |            |          |             |             | postgres=CTc/postgres
 template1  | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
            |            |          |             |             | postgres=CTc/postgres
 vagora     | vericant   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
(6 rows)

#修改配置文件为远程访问
vim /etc/postgresql/10/main/pg_hba.conf 

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    all             all             0.0.0.0/0               md5

[root@VM_4_5_centos data]# lsblk
NAME   MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda      8:0    0  110G  0 disk 
└─sda1   8:1    0  110G  0 part /
sdb      8:16   0  200G  0 disk 
└─sdb1   8:17   0  100G  0 part 
[root@VM_4_5_centos data]# 
[root@VM_4_5_centos data]# sudo mount /dev/sdb1 /data

User.all.each do |user|
  puts "Username: #{user.username}, Email: #{user.email}"
end

# 列出所有管理员用户
User.admins.each do |admin|
  puts "Username: #{admin.username}, Email: #{admin.email}"
end

# 查找用户
user = User.find_by(username: 'zjh')

# 修改密码
user.password = 'DHCPtest123'
user.password_confirmation = 'DHCPtest123'
user.save!

# 退出Rails控制台
exit

cd C:\Program Files\Microsoft SQL Server\140\Tools\Binn

#这个目录中的140可能会不一样。根据实际情况来

--- 
sqlcmd -S DESKTOP-test\TEST -U sa -P test -d test -i C:\Users\Public\数据库\test.sql


-S 数据连接信息，这里使用的是主机名进行连接
-U 用户名
-P 密码
-d 导入的数据库
-i 数据库来源