oid type

oid expresses a PostgreSQL-compatible object identifier.

Details

oid types in Materialize are provided for compatibility with PostgreSQL. You typically will not interact with the oid type unless you are working with a tool that was developed for PostgreSQL.

See the Object Identifier Types section of the PostgreSQL documentation for more details.

Valid casts

From oid

You can cast oid to:

• integer (by assignment)
• bigint (by assignment)
• text (explicitly)

To oid

You can cast from the following types to oid:

• integer (implicitly)
• bigint (implicitly)
• text (explicitly)