dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlSelectStatement Class / PgSqlSelectStatement Constructor
Example

In This Topic
PgSqlSelectStatement Constructor
In This Topic
Creates a new instance of the PgSqlSelectStatement class.
Syntax
'Declaration
 
Public Function New()
 
Example
The following example demonstrates how to use the PgSqlSelectStatement constructor.
PgSqlSelectStatement stmt = new PgSqlSelectStatement();
stmt.Columns.Add(new SelectColumn("JOB"));
stmt.Tables.Add(new SelectTable("emp"));

stmt.Distinct = true;

//select distinct JOB from emp
string queryText = stmt.ToString();
Dim stmt As New PgSqlSelectStatement
stmt.Columns.Add(New SelectColumn("JOB"))
stmt.Tables.Add(New SelectTable("emp"))
stmt.Distinct = True

'select distinct JOB from emp
Dim queryText As String = stmt.ToString
See Also