Error: make a query(query) in dao which is an alias

Question

This query normally functions in postgresql:

select nome as "pessoas?" from pessoa

But in java I did a dao which has a method called find:

sql = "select nome as 'teste?' from pessoa where id=?";

Gives the message:

ERROR: syntax error at or near "'test?'"

PS.: I am using Preparedstatement.

@Override
    public Pessoa enncontrarAlias(int id) {
    Pessoa pessoa = null;

    sql = "select nome as \"teste?\" from pessoa where id=?";

    try {
        pst = conexao.prepareStatement(sql);
        pst.setInt(1, id);
        rs = pst.executeQuery();

        while(rs.next()){
            pessoa = new Pessoa();
            pessoa.setNome(rs.getString("nome"));
        }

        rs.close();

        return pessoa;

    } catch (SQLException e) {

         throw new RuntimeException(e);     }   
}

Answer 1

Does not use single quotes as escape of caractares in postgres but double quotes, in this case add a bar to escape in java.

sql = "select nome as \"teste?\" from pessoa where id=?";

To recover the database information use alias:

rs.getString("teste?")