Re: AW: AW: Why is materialized view creation a "security-restricted operation"?

On 10/12/26 11:12 PM, Färber, Franz-Josef (StMUK) wrote:
> Thanks for the suggestion.
> But what exactly is the suggestion?

That you also read the links included, where it shows that DuckDb is
available from a multitude of languages and can connect to a Postgres
database to share information. Think it of as in-memory database to do
the scratch work that you then pass into Postgres. It is definitely a
round about way of tackling the problem.

>
> At least I understand DuckDB can directly read without having to craete a temp table:
> * SELECT * FROM 'test.csv.gz';
> * SELECT * FROM read_csv('test.csv', header = false);
>
> ... which is what Postgres is missing.
>
>
> Regards,
> Franz-Josef Färber
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com