VB.Net连接PostgreSqlDB

PostgreSQLの使い方

PostgreSQL在线教程

.NETライブラリ「Npgsql」によるPostgreSQLの活用

.NETでNpgsqlのDataReaderを使ってDataTableを作成する方法

Imports Npgsql

Public Class MainForm
    Dim myConnection As NpgsqlConnection
    Dim myConnectionString = "Server=localhost; Port=5432; User Id=postgres; Password=1; Database=myDataBase;CommandTimeout=300"

    Private Sub MainForm_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        myConnection = New NpgsqlConnection()
        myConnection.ConnectionString = myConnectionString
        myConnection.Open()

    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim cmd As NpgsqlCommand = New NpgsqlCommand()
        cmd.CommandText = "Select * from public.""myTable"""
        cmd.Connection = myConnection
        Dim dr As NpgsqlDataReader = cmd.ExecuteReader()
        Console.WriteLine("========" + dr.GetSchemaTable().Rows(0).Item(0))

    End Sub

End Class