Cmdlets for EnterpriseDB

Build 21.0.7930

Select-EnterpriseDB Cmdlet

Parameters   Output Objects  

Searches EnterpriseDB data.

Syntax

Select-EnterpriseDB [parameters]

Remarks

The Select-EnterpriseDB cmdlet allows you to use a syntax similar to SQL SELECT statements to search EnterpriseDB data.

$conn = Connect-EnterpriseDB -User 'postgres' -Password 'admin' -Server '127.0.0.1' -Port '5444' -Database 'postgres'
Select-EnterpriseDB -Connection $conn -Table "`"postgres`".`"public`".Orders" -Columns @("ShipName","ShipCity") -Where "ShipCountry='USA'"

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930