duda en paginado en pgsql

[xoceunder]

tengo problema con esto amigo

SELECT * FROM devices INNER JOIN users ON (devices.user_id = users.id) WHERE username=text

y me tira este eror

Error de SQL:

ERROR: column reference "username" is ambiguous
LINE 1: ... JOIN users ON (devices.user_id = users.id) WHERE username =...
^
En la declaración:
SELECT COUNT(*) AS total FROM (SELECT * FROM devices INNER JOIN users ON (devices.user_id = users.id) WHERE username = text) AS sub