[Answered ]-SELECT using psql returns no rows even though data is there

I guess you forgot to enter semicolon:

SELECT * FROM myapp_stories;

Prefix the table in your query with the schema, as the search_path might be causing your query (or psql) to look in a schema other than what you are expecting.