HomeОбразованиеRelated VideosMore From: randomtutorial

Move tables between databases PostgreSQL with a DBLINK

8 ratings | 3225 views
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 $$
Html code for embedding videos on your blog
Text Comments (3)
Yerkebulan Duisebay (1 month ago)
select * from dblink('dbname=', 'select * from ') as accounts_cadastres_res(kad_nomer text)
moin akther (11 months ago)
which gui tool you have used in this video ?
randomtutorial (11 months ago)
Hi. Thanks for watching. I used Navicat for Postgres.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.