Temp Tables using DBeaver and Postgres

[OscarBoots]

Hi Everyone,
I'm using a hard working db & am saving some resources by using Temp Tables.
I haven't used Postgres or DBeaver before and so I went off to Google the answer to creating a Temp Table as a Select statement, no problem there.
As we all know the temp table only lasts the session, which is fine, but I want to know how/where to use the 'ON COMMIT PRESERVE ROWS' statement as I would in Teradata but I cannot find a clear answer??
I also came across the 'DISTRIBUTED BY' clause where I've used the field I want to join onto (according to a Google search).
My question is what is the correct syntax to maintain a Temp table for use with other tables, I assume I can join to Tables/Views etc?? Any example syntax or links would be great! Thanks in advance. : )