Further to postgres on Rails in Fedora 18 but OT

[Max Pyziur]

http://lists.fedoraproject.org/pipermail/users/2013-May/435615.html

Sorry deleted your message and then was viewing it on the web.

You write:
Booking_development=> SELECT "registers".* FROM "registers" ORDER BY
lname shows nothing because it's a database not a table, but I do not
understand how to get at it's tables'.

I reply:

The syntax implies that you have a schema by the name of "registers."

Are you trying to see everything in the "registers" table?

If so, I would first check to see what tables are available in 
booking_development

>From a psql prompt, type: \dt

That should show you the tables that are in the public schema; do you also 
have other schemas? Typing
\dt *.*
can give you verbose results but it should show you other schemas if they 
are there.

If all you want to do is to see what is in the "registers" table, then 
the SQL would be:
SELECT * FROM registers ORDER BY lname
(providing "lname" is a field in the "registers" table).

Hope that helps,

Max Pyziur
pyz at brama.com