j use microsoft vb 2005 with PostgreSQLDirect.NET 2.5
PostgreSQL for windows 8.x
Using GetSchema("Indexes") with restrictions not work
example (mvarconnectionDB is a CoreLab.PostgreSql.PgSqlConnection:
Dim Dtl As System.Data.DataTable = Nothing
Dim Res(3) as String
Res(0) = Nothing 'IndexName
Res(1) = Nothing 'SchemaName
Res(2) = "Test" 'TableName
Res(3) = Nothing 'OID
Dtl = mvarConnectionDB.GetSchema("Indexes", Res)
Dtl.Rows return no rows
if j not use Res(2) = "Test" but Res(2)=nothing it work but return all indexes in database of all tables
The same problem persist in restrictions of Databases GetSchema setting a specific database name.
Another question is: how we can convert Row.Item("columns") in vb with a list of columns in the index or what is the way to read columns in an index ?
Thanks