2. Using Ingres Commands : createdb Command—Create a Database : createdb Examples
 
Share this page                  
createdb Examples
1. This command creates a database that is not Unicode enabled (that is, turns off the default behavior):
createdb -e mydb
2. This command creates a Unicode-enabled database with Normalization Form C and default collation sequence:
createdb unidb
or
createdb -i unidb
3. This command creates a Unicode-enabled database with Normalization Form D and default collation sequence:
createdb -n unidb
4. This command creates a Unicode-enabled database with Normalization Form C and the unicode_french collation sequence:
createdb -iunicode_french unidb
5. This command creates a Unicode-enabled database with Normalization Form D and a custom collation sequence:
createdb -nmyunicollation unidb
6. This command creates a Unicode-enabled private database on the default devices:
createdb -p mydb
7. This command creates the Unicode-enabled public database ericsdb using a different user name:
createdb ericsdb -ueric
8. This command creates a Unicode-enabled database with its database, checkpoint, and journal files on different devices:
createdb bigdb -ddb_ingres -cnewdev_ingres -jotherdev_ingres
9. This command creates a Unicode-enabled database with catalogs for Ingres and OpenROAD:
createdb testdb -f ingres windows_4gl
10. This command creates a Unicode-enabled distributed database for use with Ingres Star:
createdb mydb/STAR