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@xxxxxxxxx
--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org
