Complete PostgreSQL newb here.
I have 7-8 views worth of data in db1 that I need to copy into tables with matching schemae (schemas?) in a different database. The destination database may be the same instance of postgresql, or one on a different box altogether.
I know 2-3 different ways to accomplish this with the databases I'm familiar with, but I'm helpless on this one. Can someone suggest some basic strategies for me?
In a perfect world, I'd prefer not to have to do anything that feels too ETL-ish - I'd rather do some sort of SELECT FROM instance1.db1.viewname INTO instance2.db5.tablename then dump data out of the view as text file and reload into the destination table. I see postgresql has a COPY command, and that’ the sort of thing I want to avoid if I can.
Since I don't know postgreSQL, so I don't really know what is within the realm of possibility, though.
Thanks!