---$> psql: user my_user and database my_original_db must exists: SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'my_original_db' AND pid <> pg_backend_pid(); CREATE DATABASE my_new_db WITH TEMPLATE my_original_db OWNER my_user;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter