INGRES helps DESCRIPTION to insert a new table: cd /tmp copydb -c -lquel gsse tablename #creates copy.out & copy.in quel gsse < copy.out #saves data vi copy.in #first line insert: destroy tablename #in create section do: #insert new fields, or change fields, where you want #them, follow example of the other fields quel gsse < copy.in done SEE ALSO Ingres manuals