请以C#语言窗口形式从pstgres中选择所有数据库进行sql查询 [英] please give sql query for select all databases from pstgres in C# language windows form

问题描述

我知道如何从sql中选择所有数据库，它是从INFORMATION_SCHEMA.SCHEMATA中选择SCHEMA_NAME AS`Database`"


请给SQL查询以C#语言窗口形式从pstgres选择所有数据库

i know how to select all database from my sql it is "SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA"


please give sql query for select all databases from pstgres in C# language windows form

推荐答案

Try:

Try:

SELECT datname FROM pg_database WHERE datistemplate = false;

不是我的代码，它来自

Not my code, it came from http://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-with-psql-command-line-tool[^] and took me about 30 seconds to find with google.

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

In future, please try to do at least basic research yourself, and not waste your time or ours.

这篇关于请以C#语言窗口形式从pstgres中选择所有数据库进行sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！