Try :
SELECT owner from pictures group by owner;
Any ideas, apart from more or less manually maintaining a list of distinct owners in another table ?
That would be a good idea too for normalizing your database.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
