On Thu, 30 May 2013, Roger wrote:
Apologies for top post
Thanks this is most helpful
One thing that I forgot to mention is tables that are in other schemas
besides the public schema.
Personally, I don't build a database with tables in other schemas; but it
does add a way of keeping tables
Apologies for top post
Thanks this is most helpful
Roger
On Fri, 17 May 2013, Roger wrote:
On 05/16/2013 09:51 PM, Max Pyziur wrote:
[... deleted for the sake of brevity ...]
Late getting back to the party ...
Thanks Max
I though so too. I tried SELECT * FROM registers ORDER BY lname it
On Fri, 17 May 2013, Roger wrote:
On 05/16/2013 09:51 PM, Max Pyziur wrote:
[... deleted for the sake of brevity ...]
Late getting back to the party ...
Thanks Max
I though so too. I tried SELECT * FROM registers ORDER BY lname it returns
nothing, meaning the table doesn't exist or is em
On 05/16/2013 09:51 PM, Max Pyziur wrote:
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 datab
On Thu, May 16, 2013 at 19:57:46 +1000,
Roger wrote:
In sqlite, the string tables contain numbers so the rails to_i
changes them to integer for adding.
How can I do this with postgres please?
You can cast text to integer using ::integer. For example:
bruno=> select '123'::text::integer;
Am 16.05.2013 11:57, schrieb Roger:
> 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'
SQL basics
select field1,field2 from database.table;
select * from database
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 ho
Somewhat very OT and more Rails inclined but I'm hoping someone can help.
After reading on Postgres as advised I went to have a look at the Rails
tables.
Postgres is working, Rails app "Booking" is up with one table,
"reservations", which has some string fields and data has been input for
test
