请以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屋!