Was this helpful?
createdb Examples
1. Create a database that is not Unicode enabled (turn off the default behavior):
createdb -e mydb
2. Create a Unicode-enabled database with Normalization Form C and default collation sequence:
createdb unidb
or
createdb -i unidb
3. Create a Unicode-enabled database with Normalization Form D and default collation sequence:
createdb -n unidb
4. Create a Unicode-enabled database with Normalization Form C and the unicode_french collation sequence:
createdb -iunicode_french unidb
5. Create a Unicode-enabled database with Normalization Form D and a custom collation sequence:
createdb -nmyunicollation unidb
6. Create a Unicode-enabled private database on the default devices:
createdb -p mydb
7. Create the Unicode-enabled public database ericsdb using a different user name:
createdb ericsdb -ueric
8. Create a Unicode-enabled database with its database, checkpoint, and journal files on different devices:
createdb bigdb -ddb_ingres -cnewdev_ingres -jotherdev_ingres
9. Create a Unicode-enabled database with catalogs for Ingres and OpenROAD:
createdb testdb -f ingres windows_4gl
10. Create a Unicode-enabled distributed database for use with Ingres Star:
createdb mydb/STAR
Last modified date: 01/30/2023