Starting Ingres

From SQLZOO
Jump to navigation Jump to 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

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects