Move tables between databases PostgreSQL with a DBLINK
Blog:
http://bearsnack.co.uk
Move tables between databases PostgreSQL with a DBLINK
do $$ declare r record ;
begin
for r in select *
from dblink ('host=localhost
user=postgres
password=password
dbname=source',
'select indexdef
from pg_indexes
where tablename = ''mytable''') as linktable (
indexdef text ) loop
execute r.indexdef;
end loop;
end $$
On this page of the site you can watch the video online Move tables between databases PostgreSQL with a DBLINK with a duration of hours minute second in good quality, which was uploaded by the user randomtutorial 08 April 2017, share the link with friends and acquaintances, this video has already been watched 25,038 times on youtube and it was liked by 100 viewers. Enjoy your viewing!
