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