string script =
"DROP TABLE DEPT;"+
"CREATE TABLE DEPT ("+
" DEPTNO INT PRIMARY KEY,"+
" DNAME VARCHAR(14),"+
" LOC VARCHAR(13)"+
")WITH OIDS;"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
PgSqlConnection pgConn = new PgSqlConnection(
"host=server;database=test;user id=postgres;");
PgSqlScript pgScript = new PgSqlScript(script,pgConn);
SqlStatementCollection pgColl = pgScript.Statements;
IDataReader pgReader;
pgConn.Open();
foreach (SqlStatement pgStatement in pgColl)
{
Console.WriteLine(pgStatement.Text);
try
{
pgReader = pgStatement.Execute();
Console.WriteLine(" Records affected " + pgReader.RecordsAffected);
while (pgReader.Read())
{
Console.WriteLine(pgReader.GetString(0));
}
pgReader.Close();
Console.WriteLine();
}
catch
{
Console.WriteLine(" Failed");
}
}
pgConn.Close();