Temporary Tables?

[kairoswater-jason]

Backend

PostgreSQL

Diesel version

2.3.0

What do you want to do?

Does the diesel dsl/etc. have any support for generating or interacting with temporary tables? It would be nice to use little to no raw SQL.

I'd be happy to put a 'bogus' table entry in schema.rs to represent a temporary table even if the table isn't guaranteed to exist all of the time.

To be honest I haven't experimented with this at all, so for all I know it might be no different the working with a regular table. (the intent being to do something like a COPY from the temporary table into a real table to perform a quick and atomic update of every record in a particular regular table)

Checklist

• I have already looked over the issue tracker and the discussion forum for similar possible closed issues.

[weiznich]

The DSL provided by diesel just works with a temporary table if you manually write the corresponding diesel::table! {} call somewhere.

Creating and deleting such tables is not supported by the built-in DSL, but you can extend it to support that as well. The internal diesel_tests crate contains a basic DSL for this that can be used as starting point: https://github.com/diesel-rs/diesel/blob/main/diesel_tests/tests/schema_dsl/structures.rs