Starting Ingres

From SQLZOO
Revision as of 10:43, 19 July 2012 by Connor (Talk | contribs) (Created page with "<table border="1"> <tr> <th colspan="1" rowspan="1" width="296">Name of the server</th> <td colspan="1" rowspan="1" width="576">ingres</td> </tr> <tr> <th colspan="1" rowspan...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Name of the server ingres
Name of the client sql also isql
Typical command line to start the client source ~ingres/.ingIIbash
sql iidbdb

server

iidbdb is the system database - where you create users and databases

operating system authentication

Ingres relies on the operatong system for authentication.

Useful commands
help\g
Beware!

Put \g at the end of each sql command