information_schema.tables.is_insertable_into

mysql

mariadb

tidb

postgres

type: YES_OR_NO NULL
Note:
YES if the table is insertable into, NO if not (Base tables are always insertable into, views not necessarily.)
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
YES if the table is insertable into, NO if not (Base tables are always insertable into, views not necessarily.)
© 1996-2022 The PostgreSQL Global Development Group
8.2-9.6

cockroachdb

mssql