Some update, i used the same method now with a mysql database, and here it does exacly what i want.

SELECT id, user FROM view (an example)

and it shows me what i want.