使用Npgsql连接Postgres

listen_addresses = '*'  

host    all         all         0.0.0.0/0          trust

  string strConn = ConfigurationManager.ConnectionStrings["npgsql"].ConnectionString;
            var conn = new NpgsqlConnection(strConn);

            string sql = "select * from test";
            var dt = new DataTable();

            var cmd = new NpgsqlDataAdapter(sql, conn);

            cmd.Fill(dt);

            foreach (DataRow row in dt.Rows)
            {
                Console.WriteLine(row["xxxx"].ToString());
            }
            conn.Close();
            Console.Read();