Untitled

<?php

$con = pg_connect("host=localhost dbname=aveiro port =5432 user=pedro password=****");

$query = "SELECT DISTINCT rua AS nome FROM ruas";

$lista = pg_query($con,$query);

pg_close($con);

while ($row=pg_fetch_array($lista)) {

    $nomes=$row["nome"];
}

?>


<!DOCTYPE html>
<html>
<body>

<h1>Testes</h1>


<select name="rua">
<option value="">Selecione o nome de rua</option>
<option value="<?=$nomes?>"><?=$nomes?></option>
</select>


</body>
</html>