我该如何使用C#和Npgsql获取用户计算机上所有可用的PostgreSQL数据库列表?
在postgreSQL中有两种方法可以实现:
\l
SELECT datname FROM pg_database;
Npgsql
? - EgoPingvinaNpgsql
,您可以使用以下代码片段:IEnumerable<string> GetDatabaseNames()
{
var connStrBuilder = new NpgsqlConnectionStringBuilder();
connStrBuilder.Host = "localhost";
connStrBuilder.Username = "theduck";
connStrBuilder.Password = "password123";
connStrBuilder.Database = "postgres"; // this database is always present
using (var conn = new NpgsqlConnection(connStrBuilder.ConnectionString))
{
conn.Open();
using (var command = new NpgsqlCommand("SELECT datname FROM pg_database WHERE datistemplate = false ORDER BY datname;", conn))
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
yield return reader.GetString(0);
}
}
}
}
select datname from pg_database;
。 - ta.speot.is