In Postgresql 10 one can gain huge performance improvements by using parallelism. Parallel query execution is however possible only for SELECT queries, while not possible for any DDL statements including SELECT...INTO or CREATE TABLE AS SELECT...statements.
I have a CREATE TABLE AS SELECT.. type of query, which cannot utilize parallelism. In order to utilize Postgresql query parallelism, I intend to turn the query into normal SELECT query and then save resultset back to database, as a table.
How can I save TSQLQuery resultset back to database as a table?