Документація

SELECT * FROM Назва таблиці

string query = $"SELECT name FROM {table} WHERE uid = @uid";

NpgsqlCommand command = DataSource.CreateCommand(query);
command.Parameters.AddWithValue("uid", 1);

NpgsqlDataReader reader = command.ExecuteReader();

while (reader.Read())
	var name = reader["name"];

reader.Close();