DEV Community

Peter Prentice
Peter Prentice

Posted on

database conversion

Very new to this forum so bear with me if I sound stupid. What I'm trying to do is to select from a database a table that has a structure and then what I wish to do is to insert this table with a different structure into a new database. for example select from old database datatable1 data1, data2, data3 and then insert into new database datatable2 data2, data1, data3. Is this possible or am I just barking up the wrong tree and should be using some other development language.
Any suggestions will be appreciated.
Best Regards,
Peter

Top comments (0)

Billboard image

Create up to 10 Postgres Databases on Neon's free plan.

If you're starting a new project, Neon has got your databases covered. No credit cards. No trials. No getting in your way.

Try Neon for Free →

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay