postgresql - Postgres ODBC 驱动模块

Question

总体问题是:我需要从 PowerShell 连接到 Postgres 数据库。我发现，我需要先安装 ODBC 驱动程序。但是，我需要我的脚本可以重新分发到不同的机器，而且我负担不起到处安装 ODBC。是不是有某种 PowerShell ODBC 模块，我可以简单地导入到 PS session 中，然后我可以用它来连接到数据库？谢谢。

Answer 1

要在评论中回答您的问题，您可以执行以下操作(使用 PS 3.0 功能):

# List assemblies loaded
[appdomain]::currentdomain.getassemblies()

# May have to tweak 2nd argument to -like
$asm= [appdomain]::currentdomain.getassemblies() | ? name -like *npgssql* 

# look at all the types in the assembly
$asm.gettypes() | out-gridview

# Pick a class that looks interesting, filter it out
$typeToExamine = $asm.gettypes() | ? name -like *whateverlooksinteresting*

$typeToExamine.getproperties()|select name
# or alternatively
$typeToExamine.getproperties()|out-gridview

# similarly with $typeToExamine.getmethods()

# Or an alternative to getMethods()/getProperties() is to create an instance
# of the type and use get-member