pg_dump support

[CodingFu]

HI everyone.
I'm trying to run this on very interesting env: Internet Computer blockchain

I have a very simple question:

If I run it in memory, how do I dump memory to a string and then load it from string to memory?

[samwillis]

A could of updates on this:

1. In 'main' we have support for COPY TO/FROM using a special '/dev/blob' device. This enables import to/from CSV and a Postgres binary format.
2. Our 'next' branch has support for loading and dumping the database dir as a tar.gz, this will be merged soon PGlite Next - Based on Postgres 16.x #112
3. We are looking into how to support pg_dump and related tools to export/import a database.

[neutralboy]

Hey @samwillis,
I'd just like to add to the fact that supporting pg_dump / pg_restore would allow pglite to be used as a mock in tests with full extension support. This sounds exciting to me, Id' like to help if someone is already working on it or start a PR myself.