<?php
$dbconn = pg_connect("dbname=Tarea2 host=localhost port=5432 user=Tarea password=tarea");
if (!$dbconn){
	echo "Error en la conección \n";
	exit;
}
pg_query("SET search_path TO public");
$result= pg_query($dbconn,'SELECT * FROM "Casa_nobleza"');
if (!$result){
	echo "Error en el query\n";
	exit;
}

while ($row = pg_fetch_row($result)) {
	echo "Patata: $row[0]";
	echo "<br /> \n";
}
echo "se acabo \n";
?>