Feature Request: Push tables to an existing PostgreSQL server

[nogurtMon]

Feature request

Is your feature request related to a problem? Please describe.

I want a streamlined way to push tables from postgres.new to an existing PostgreSQL server.

It is difficult to push tables from postgres.new to an existing PostgreSQL database. The only option is .tar, which is a bad option. When using .tar, errors are thrown on transfer if the sending server's PostgreSQL version does not match the receiving server's PostgreSQL version.

Describe the solution you'd like

Not quite sure. An ironclad way to transfer tables.

Describe alternatives you've considered

.tar

Additional context

Add any other context or screenshots about the feature request here.

[gregnr]

Thanks @nogurtMon - we're working with @samwillis to support this via a WASM version of pg_dump. Stay tuned!

[ajerni]

@gregnr and @samwillis: Will this also work the other way round? Downloading a table from an existing hosted PostgreSQL server to use it in database.build with the LLM assistant. That would be another feature request.