search

supabase-community / postgres-new

In-browser Postgres sandbox with AI assistance
https://database.build
Apache License 2.0
2.34k stars 183 forks source link

Feature Request: Push tables to an existing PostgreSQL server #79

Open nogurtMon opened 2 months ago

nogurtMon commented 2 months ago

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 commented 2 months ago

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

ajerni commented 1 week ago

@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.