I'm new to pgAdmin4 and performing tests before jumping in the deep end.
I've uploaded a large dataset into a the public schema within a database named 'spatial_db'. Rather than re-uploading the data to a new database through the DB Manager in QGIS, is there a way to transfer the spatial data in the public schema of the new database as shown below?
I'm conscious that moving the table alone, will only bring the attribute table across but perhaps I have this wrong, will it will bring the geometry across too?
pg_dump[all]) and restore it. For data-only transfers, there are plenty of more or less fit options, e.g.
db_link, CSV export...