Live Demonstration

- Table Editor

RTA comes with a table editor which lets you view and edit any of the tables in your RTA program. The table editor is composed of four short PHP programs which use the information in the two system tables to figure out how to display and edit the other tables in the program.

Click on the link below to give it a try.

• http://www.linuxappliancedesign.com/projects/rta/rta_tables.php

You might want to try changing one of the "notes" fields in mytable. Be sure to hit 'reload' to see the effect of your changes.

- Direct psql Access

If you have the 7.2 or later PostgreSQL command line tool psql on your system you can access our demo application directly with

     psql -h www.linuxappliancedesign.com -p 8888

Once connected, try a few of the following simple SQL commands.

     SELECT * FROM mytable;
     UPDATE mytable SET myint=4 LIMIT 5 OFFSET 10;
     SELECT * FROM mytable;
     UPDATE mytable SET notes="Hi Mom!" LIMIT 1 OFFSET 0;
     SELECT name FROM rta_tables;
     \q