36.7. Field Types

PostgreSQL has a large number of field types, all of which are supported by Webmin. Not all of them are particularly useful for the average database, however. Those that are commonly used are listed in Table 36.1.

PostgreSQL has several types for storing geometric objects, such as point, path, box, and circle, and types for network information such as inet, cidr, and macaddr. Fields of all these types can be created and edited using this module, even though they are not documented above. No other databases (such as Oracle or MySQL) support these types, however, so it may be wise to avoid them if you want your programs to be database-independent.

Table 36.1. PostgreSQL Field Types
TypeDescription
charA fixed length string of text, ...

Get Managing Linux® Systems with Webmin™ System Administration and Module Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.