PostgreSQL and Visual Basic - Programming

[FatOldGit]

Many apologies if this has previously been asked and answered, the search facilities aren't working at the moment.
I need to create a VB app that will work with a PostgreSQL DB. Apart from reading data (views, tables and the like) which I can do, I need to be able to create views, indexes, etc through code. I have tried adding a reference to the pgSchema and can declare objects but most of the properties and methods seem to be read only and even though I 'SET' the objects I still get the "object variable not set" error.
Please can someone point out where I am going wrong.

Many thanks in advance,

Dave.

 

[stoolpigeon]

if you post some code I could take a look at it and maybe help

right off the bat though- you could just write the sql to create what you need and execute that through your connection. no need to create anything beyond a connection and the appropriate statements.

 

[FatOldGit]

Hi, thanks for the reply. I have tried the SQL route and it works fine. It looks like I did my usual trick and tried to be too clever.

Many thanks,

Dave.