Cmdlets for CockroachDB

Build 24.0.9060

Select-CockroachDB Cmdlet

Parameters   Output Objects  

Searches CockroachDB data.

Syntax

Select-CockroachDB [parameters]

Remarks

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

$conn = Connect-CockroachDB -User 'root' -Password 'root' -Server 'localhost' -Port '26257' -Database 'system'
Select-CockroachDB -Connection $conn -Table "`"defaultdb`".`"public`".Orders" -Columns @("ShipName","ShipCity") -Where "ShipCountry='USA'"

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060