It is. They even consider it a feature.

You don't actually need to specify column types at all. You can just leave them out. Or make up entirely new types.

Foreign key constraints are also not enforced by default but there is at least an option to turn that on.