USING heap
keyword.
default_table_access_method
to heap.
ALTER USER
, that user must also be a superuser to use rowstore tables. Superuser can be granted to any user:
heap
, CREATE TABLE will create a heap table without needing to add USING heap.
With the default changed, to create a Postgres columnstore table you must include the USING duckdb
keyword.
Limitations
SELECT duckdb.raw_query($$ ALTER TABLE ... ; $$)
to execute directly with DuckDB.
json
duckdb
.#>
and #>>
JSON operators are not supported when running a query that uses analytics tables.using duckdb
, these views cannot be refreshed.REFERENCES
, ON DELETE CASCADE