-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = public, pg_catalog; -- -- Data for Name: activesql2008; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY activesql2008 (short_code) FROM stdin; 01909 01acb 01fd0 031dc 03377 0457a 05484 061d6 07145 085fd 08d58 0a9e1 0aac38 0aff2 0c5cc 0cc80 0d0f3 1098e1 11930 123a4 1396f 13abf8 14b43 163d4 16ffb 1752f 17cdc 181f3 18b3e 1b365 1c400 1c581 1c87a 1d348 1de7c 1e761 1ebd6 1fa93 20167 20a68 213bd 214a3 21d83 23cd6 23f23 2464a 24d57 24eb4 2584e7 261c1 2682f 27a33 283cd 28de8 29cf9 2a27a 2a7f3 2a85f 2bb27a 2bd7d 2bfc5 2cfa3 2dae8 2dbfdb 2eee5 2f86a 30354 305b1 311a4 32b46 35a5a 362dd 36802 38f7d 3944a 3b260 3bd51 3bf14 3c000 3f1f0 3f54c 3fe32 3ffd8 4298f 43333 43413 4360f 4377a 4526f 463d8 46a40 46e9e 46fad 47a3d 49351 49ca3 4b0fc 4bfec 4c274 4dab5 4e17b 4f199 50125 50774 510db 51ba7 51faf 520a7 52b3f 5412f 55cc6 565ba 56e8e 57163 57668 59294 5b49e 5b941 5bba4 5bc65 5ca1c 5dc19 5e1ef 5f377 5fcce 60692 64ee4 691d7 69203 693dc 694c4 69ac1 6c4f4 6c65c 6c9ec 6cbc4 6e072 6e0e5 6effc 7021e 710a2 71148 71968 71ebb 72838 73039 73d77 766ce 78c4c 79131 79981 7afe7 7bc5e 7c015 7d0cf 7d229 7d240 7db93b 7e172 7e722 7e8c8 7fbc0 80c2c 81c5e 84d03 8610f8 86469 86ebf 873a3 8871e 8912a 892ec 89828 89d5e 8a2e8 8a396 8a4c03 8a59d 8aa01 8ab7e 8b91b 8c0b7 8cc20 8d907 8da2b 8e2fc 9198c 919c2 92789 92b99 93298 937ce 93c30 948ba 94dc4 957df 95cd3 9822e 98c44 98de8 99345 9ad24 9bd91 9c4dc 9c867 9cd73 9d69d 9db88 9f7d4 a1126 a2300 a2452 a2c70 a2efeb a325bf a45c5 a4f02 a592c a65c5 a69d6 a70be a88f7 a9718 aa12d ab4d5 ab4d8 abecc ac1ff ad17b ad7d7 ade9a adff0 aed07 af0df af437 afed1 b190b b1e2a b3322 b4935 b6112 b6f25 b79fa b7a7b b896ff b9318 baaf9 bafef bb339 bb625 bd3c8 bd7a3 beaf8 beea4 bf9c5 c199a c264e c2cb0 c39a2 c464b c5e9c c7d89 c7e34 c8cc0 c937c c95f8 cabe8 cad0b cadd4 caff3 cb849 cce694 cd164 cd287 cd599 cdfb2 ce1c7 cf44e cfa70 d1511 d2c91 d41d8 d48ae d5d0da d61da d7bda d7ee6 d82d8 dabfb db1ad db3d2 db918 dbc28 de0fe de39a e01ee e08bf e2d56 e30002 e35ef e3ed6 e45a6 e56fc e6e41 e78d2 e7bec e8ad4 e8da4 e9815 ea610 ebe7c ece64 edc26 efc26 f080f f0ec6 f13e3 f1af2 f20e6 f2e05 f2fff f3119 f5c23 f7c10 f8b49 f8d24 f9295 f9547 fa876 fc175 fe19c fe2fb fed62 ff26e \. -- -- Data for Name: db_types; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY db_types (id, full_name, simple_name, setup_script_template, jdbc_class_name, drop_script_template, custom_jdbc_attributes, batch_separator, notes, sample_fragment, execution_plan_prefix, execution_plan_suffix, execution_plan_xslt, context, execution_plan_check, is_latest_stable, list_database_script) FROM stdin; 7 SQLite (WebSQL) SQLite \N websql \N \N \N \N 7/04eca/1 \N \N \N browser \N 1 \N 5 SQLite (SQL.js) SQLite \nCREATE USER user_#databaseName# PASSWORD '#databaseName#' sqljs \N \N \N \N 5/781d4/2 \N \N \N browser \N 1 \N 2 MySQL 5.5.32 MySQL \nCREATE database db_#databaseName# default CHARACTER SET = utf8 default COLLATE = utf8_general_ci;\nGRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,CREATE TEMPORARY TABLES,CREATE VIEW,SHOW VIEW,ALTER ROUTINE,CREATE ROUTINE,TRIGGER,EXECUTE\n ON db_#databaseName#.* TO user_#databaseName#@'%' IDENTIFIED BY '#databaseName#';\n org.gjt.mm.mysql.Driver \n DROP DATABASE db_#databaseName#; drop user user_#databaseName#@'%';\n allowMultiQueries=true \N Separate multiple statements in MySQL by terminating each one with a semicolon. 2/a2581/1 explain extended \N \N host \N 1 show databases 6 MS SQL Server 2012 SQL Server \nCREATE DATABASE db_#databaseName#;\nGO\n\nUSE db_#databaseName#;\nGO\n\nCREATE LOGIN user_#databaseName#\nWITH PASSWORD = '#databaseName#';\nGO\n\nCREATE USER user_#databaseName#;\nGO\n\nGRANT \nCREATE TABLE,\nCREATE TYPE,\nCREATE VIEW,\nCREATE PROCEDURE,\nCREATE FUNCTION,\nCREATE FULLTEXT CATALOG,\nEXECUTE,\nDELETE,\nINSERT,\nREFERENCES,\nSELECT,\nSHOWPLAN,\nUPDATE\nTO user_#databaseName#;\nGO\n\n\n\nALTER LOGIN user_#databaseName# WITH DEFAULT_DATABASE=db_#databaseName#;\nGO\n\nGRANT ALTER ON SCHEMA::dbo TO user_#databaseName#;\nGO\n\nuse master;\n\n net.sourceforge.jtds.jdbc.Driver exec dbo.clearDBUsers 'db_#databaseName#';\nGO\ndrop database db_#databaseName#;\nGO\ndrop login user_#databaseName#;\n \N GO \N 6/189a3/1 \nSET SHOWPLAN_XML ON;\nGO\n \nGO\nSET SHOWPLAN_XML OFF \n\n\n \n\n \n \n \n \n\n \n \n \n \n\n \n \n
\n \n
\n \n \n \n \n
\n
\n
\n \n \n \n \n \n
\n
\n
\n
\n \n\n \n \n
\n
\n
\n \n \n
\n \n\n \n \n \n \n \n Cached plan size\n \n \n \n Physical Operation\n \n \n \n Logical Operation\n \n \n \n Actual Number of Rows\n \n \n \n \n Estimated I/O Cost\n \n \n \n \n \n \n \n \n Estimated CPU Cost\n \n \n \n \n \n \n \n \n Number of Executions\n \n \n \n Degree of Parallelism\n \n \n \n Memory Grant\n \n \n \n \n Estimated Operator Cost\n \n \n \n \n \n \n \n \n \n \n \n ()\n \n \n \n \n Estimated Subtree Cost\n \n \n \n \n \n \n \n Estimated Number of Rows\n \n \n \n \n Estimated Row Size\n \n \n \n \n \n Ordered\n \n \n True\n False\n \n \n \n \n Node ID\n \n \n
\n \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n .\n \n \n \n \n \n .\n \n \n \n \n\n \n \n \n \n
Cost:
\n \n\n \n \n\n \n\n \n \n
Object
\n
\n \n\n \n
Predicate
\n
\n \n\n \n
Output List
\n \n
\n \n \n\n \n
Outer References
\n \n
\n \n \n\n \n
Statement
\n
\n \n\n \n
Order By
\n \n
\n \n \n Ascending\n Descending\n \n
\n \n \n\n \n\n \n\n \n \n \n qp-icon-\n \n \n\n \n \n \n qp-icon-\n \n \n \n \n \n
\n \n\n \n \n
\n \n\n \n\n \n
\n \n\n \n
\n \n\n \n\n \n \n \n \n \n \n \n
\n \n …\n
\n \n\n \n \n
()
\n \n\n \n \n\n \n\n Insert input rows into the table specified in Argument field.\n Compute new values from existing values in a row.\n Sort the input.\n Scanning a clustered index, entirely or only a range.\n Compute summary values for groups of rows in a suitably sorted stream.\n Use each row from the top input to build a hash table, and each row from the bottom input to probe into the hash table, outputting all matching rows.\n Bitmap.\n Scanning a particular range of rows from a clustered index.\n Scan a particular range of rows from a nonclustered index.\n\n Repartition Streams.\n An operation involving parallelism.\n \n Scan rows from a table.\n For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.\n Select the first few rows based on a sort order.\n\n \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n\n \n \n \n\n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n 1\n \n \n \n 0.\n \n 1\n \n 1\n \n \n \n \n \n \n\n host //*[@StatementType="COMMIT TRANSACTION"] 1 SELECT name as [schema_name] FROM master..sysdatabases 8 MySQL 5.1.61 MySQL \nCREATE database db_#databaseName# default CHARACTER SET = utf8 default COLLATE = utf8_general_ci;\nGRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,CREATE TEMPORARY TABLES,CREATE VIEW,SHOW VIEW,ALTER ROUTINE,CREATE ROUTINE,TRIGGER,EXECUTE\n ON db_#databaseName#.* TO user_#databaseName#@'%' IDENTIFIED BY '#databaseName#';\n org.gjt.mm.mysql.Driver \n DROP DATABASE db_#databaseName#; drop user user_#databaseName#@'%';\n \N \N \N 8/a2581/1 explain extended \N \N host \N 0 show databases 10 PostgreSQL 8.3.20 PostgreSQL \n\nCREATE USER user_#databaseName# PASSWORD '#databaseName#';\nCREATE DATABASE db_#databaseName# OWNER user_#databaseName# ENCODING 'UTF8' TEMPLATE db_template;\ncommit;\nALTER USER user_#databaseName# SET statement_timeout = 30000;\nSELECT dblink_connect('#databaseName#', 'dbname=db_#databaseName# hostaddr=127.0.0.1');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE deferred_check (id INT PRIMARY KEY)');\nSELECT dblink_exec('#databaseName#', 'INSERT INTO deferred_check VALUES (1)');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE db_#databaseName#.public.deferred_#databaseName# (fk INT NOT NULL)');\nSELECT dblink_exec('#databaseName#', 'ALTER TABLE ONLY deferred_#databaseName# ADD CONSTRAINT deferred_#databaseName#_ref FOREIGN KEY (fk) REFERENCES deferred_check(id) DEFERRABLE INITIALLY DEFERRED');\nSELECT dblink_exec('#databaseName#', 'GRANT INSERT ON deferred_#databaseName# TO user_#databaseName#');\nSELECT dblink_disconnect('#databaseName#');\n\n org.postgresql.Driver SELECT pg_terminate_backend(pg_stat_activity.procpid) FROM pg_stat_activity WHERE upper(pg_stat_activity.datname) = 'DB_#databaseName#'; DROP DATABASE db_#databaseName#;DROP USER user_#databaseName#; \N \N \N 10/f9585/1 explain \N \N host \N 0 select datname as schema_name from pg_database 9 MySQL 5.6.6 m9 MySQL \nCREATE database db_#databaseName# default CHARACTER SET = utf8 default COLLATE = utf8_general_ci;\nGRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,CREATE TEMPORARY TABLES,CREATE VIEW,SHOW VIEW,ALTER ROUTINE,CREATE ROUTINE,TRIGGER,EXECUTE\n ON db_#databaseName#.* TO user_#databaseName#@'%' IDENTIFIED BY '#databaseName#';\nGRANT SELECT ON performance_schema.* TO user_#databaseName#@'%';\n org.gjt.mm.mysql.Driver \n DROP DATABASE db_#databaseName#; drop user user_#databaseName#@'%';\n \N \N \N 9/a2581/1 explain extended \N \N host \N 0 show databases 12 PostgreSQL 9.2.4 PostgreSQL \n\nCREATE USER user_#databaseName# PASSWORD '#databaseName#';\nCREATE DATABASE db_#databaseName# OWNER user_#databaseName# ENCODING 'UTF8' TEMPLATE db_template;\ncommit;\nALTER USER user_#databaseName# SET statement_timeout = 30000;\nSELECT dblink_connect('#databaseName#', 'dbname=db_#databaseName# hostaddr=127.0.0.1');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE deferred_check (id INT PRIMARY KEY)');\nSELECT dblink_exec('#databaseName#', 'INSERT INTO deferred_check VALUES (1)');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE db_#databaseName#.public.deferred_#databaseName# (fk INT NOT NULL)');\nSELECT dblink_exec('#databaseName#', 'ALTER TABLE ONLY deferred_#databaseName# ADD CONSTRAINT deferred_#databaseName#_ref FOREIGN KEY (fk) REFERENCES deferred_check(id) DEFERRABLE INITIALLY DEFERRED');\nSELECT dblink_exec('#databaseName#', 'GRANT INSERT ON deferred_#databaseName# TO user_#databaseName#');\nSELECT dblink_disconnect('#databaseName#');\n\n org.postgresql.Driver SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE upper(pg_stat_activity.datname) = 'DB_#databaseName#'; DROP DATABASE db_#databaseName#;DROP USER user_#databaseName#;\n\t \N \N \N 12/6d80e/1 explain \N \N host \N 0 select datname as schema_name from pg_database 11 PostgreSQL 8.4.17 PostgreSQL \n\nCREATE USER user_#databaseName# PASSWORD '#databaseName#';\nCREATE DATABASE db_#databaseName# OWNER user_#databaseName# ENCODING 'UTF8' TEMPLATE db_template;\ncommit;\nALTER USER user_#databaseName# SET statement_timeout = 30000;\nSELECT dblink_connect('#databaseName#', 'dbname=db_#databaseName# hostaddr=127.0.0.1');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE deferred_check (id INT PRIMARY KEY)');\nSELECT dblink_exec('#databaseName#', 'INSERT INTO deferred_check VALUES (1)');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE db_#databaseName#.public.deferred_#databaseName# (fk INT NOT NULL)');\nSELECT dblink_exec('#databaseName#', 'ALTER TABLE ONLY deferred_#databaseName# ADD CONSTRAINT deferred_#databaseName#_ref FOREIGN KEY (fk) REFERENCES deferred_check(id) DEFERRABLE INITIALLY DEFERRED');\nSELECT dblink_exec('#databaseName#', 'GRANT INSERT ON deferred_#databaseName# TO user_#databaseName#');\nSELECT dblink_disconnect('#databaseName#');\n\n org.postgresql.Driver SELECT pg_terminate_backend(pg_stat_activity.procpid) FROM pg_stat_activity WHERE upper(pg_stat_activity.datname) = 'DB_#databaseName#'; DROP DATABASE db_#databaseName#;DROP USER user_#databaseName#; \N \N \N 11/6d80e/1 explain \N \N host \N 0 select datname as schema_name from pg_database 4 Oracle 11g R2 Oracle \ncreate user user_#databaseName# identified by "#databaseName#" default tablespace fiddledata profile fiddleusers\n/\ngrant create session, create synonym, create table, create type, create view, create materialized view, create procedure, create sequence, create trigger to user_#databaseName#\n/\nalter user user_#databaseName# quota 5M on fiddledata\n/\ncreate table system.deferred_#databaseName# (val NUMBER(1) CONSTRAINT deferred_#databaseName#_ck CHECK(val =1) DEFERRABLE INITIALLY DEFERRED)\n/\ngrant insert on system.deferred_#databaseName# to user_#databaseName#\n/\n oracle.jdbc.OracleDriver DECLARE\n l_cnt integer;\nBEGIN\n EXECUTE IMMEDIATE 'alter user user_#databaseName# account lock';\n FOR x IN (SELECT *\n FROM v$session\n WHERE username = 'USER_#databaseName#')\n LOOP\n EXECUTE IMMEDIATE 'alter system disconnect session ''' || x.sid || ',' || x.serial# || ''' IMMEDIATE';\n END LOOP;\n\n -- Wait for as long as it takes for all the sessions to go away\n LOOP\n SELECT COUNT(*)\n INTO l_cnt\n FROM v$session\n WHERE username = 'USER_#databaseName#';\n EXIT WHEN l_cnt = 0;\n dbms_lock.sleep( 1 );\n END LOOP;\n\n EXECUTE IMMEDIATE 'drop user user_#databaseName# cascade';\n\n EXECUTE IMMEDIATE 'drop table system.deferred_#databaseName#';\nEND; \N / Oracle does not support multiple statements in batch. Separate each statement with a line consisting of a single /, and do not terminate statements with semicolons. 4/9bbe9/2 \n\texplain plan set STATEMENT_ID = '#schema_short_code#/#query_id#' for \n \n\n\n/\n\nselect dbms_xplan.display_plan(format=>'ALL', type=>'ACTIVE', statement_id => '#schema_short_code#/#query_id#') as XPLAN FROM dual \n\n\n\n\n \n
\n\n\n host \N 1 select distinct replace(owner, 'USER', 'DB') as schema_name from dba_objects 3 MS SQL Server 2008 SQL Server \nCREATE DATABASE db_#databaseName#;\nGO\n\nUSE db_#databaseName#;\nGO\n\nCREATE LOGIN user_#databaseName#\nWITH PASSWORD = '#databaseName#';\nGO\n\nCREATE USER user_#databaseName#;\nGO\n\nGRANT \nCREATE TABLE,\nCREATE TYPE,\nCREATE VIEW,\nCREATE PROCEDURE,\nCREATE FUNCTION,\nCREATE FULLTEXT CATALOG,\nEXECUTE,\nDELETE,\nINSERT,\nREFERENCES,\nSELECT,\nSHOWPLAN,\nUPDATE\nTO user_#databaseName#;\nGO\n\n\n\nALTER LOGIN user_#databaseName# WITH DEFAULT_DATABASE=db_#databaseName#;\nGO\n\nGRANT ALTER ON SCHEMA::dbo TO user_#databaseName#;\nGO\n\nuse master;\n\n net.sourceforge.jtds.jdbc.Driver exec dbo.clearDBUsers 'db_#databaseName#';\nGO\ndrop database db_#databaseName#;\nGO\ndrop login user_#databaseName#;\n \N GO SQL Server supports multiple statements in a batch separated by semicolons. Separate statement batches with a line consisting of a single GO command, as needed. 3/1fa93/1 \nSET SHOWPLAN_XML ON;\nGO\n \nGO\nSET SHOWPLAN_XML OFF \n\n\n \n\n \n \n \n \n\n \n \n \n \n\n \n \n
\n \n
\n \n \n \n \n
\n
\n
\n \n \n \n \n \n
\n
\n
\n
\n \n\n \n \n
\n
\n
\n \n \n
\n \n\n \n \n \n \n \n Cached plan size\n \n \n \n Physical Operation\n \n \n \n Logical Operation\n \n \n \n Actual Number of Rows\n \n \n \n \n Estimated I/O Cost\n \n \n \n \n \n \n \n \n Estimated CPU Cost\n \n \n \n \n \n \n \n \n Number of Executions\n \n \n \n Degree of Parallelism\n \n \n \n Memory Grant\n \n \n \n \n Estimated Operator Cost\n \n \n \n \n \n \n \n \n \n \n \n ()\n \n \n \n \n Estimated Subtree Cost\n \n \n \n \n \n \n \n Estimated Number of Rows\n \n \n \n \n Estimated Row Size\n \n \n \n \n \n Ordered\n \n \n True\n False\n \n \n \n \n Node ID\n \n \n
\n \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n .\n \n \n \n \n \n .\n \n \n \n \n\n \n \n \n \n
Cost:
\n \n\n \n \n\n \n\n \n \n
Object
\n
\n \n\n \n
Predicate
\n
\n \n\n \n
Output List
\n \n
\n \n \n\n \n
Outer References
\n \n
\n \n \n\n \n
Statement
\n
\n \n\n \n
Order By
\n \n
\n \n \n Ascending\n Descending\n \n
\n \n \n\n \n\n \n\n \n \n \n qp-icon-\n \n \n\n \n \n \n qp-icon-\n \n \n \n \n \n
\n \n\n \n \n
\n \n\n \n\n \n
\n \n\n \n
\n \n\n \n\n \n \n \n \n \n \n \n
\n \n …\n
\n \n\n \n \n
()
\n \n\n \n \n\n \n\n Insert input rows into the table specified in Argument field.\n Compute new values from existing values in a row.\n Sort the input.\n Scanning a clustered index, entirely or only a range.\n Compute summary values for groups of rows in a suitably sorted stream.\n Use each row from the top input to build a hash table, and each row from the bottom input to probe into the hash table, outputting all matching rows.\n Bitmap.\n Scanning a particular range of rows from a clustered index.\n Scan a particular range of rows from a nonclustered index.\n\n Repartition Streams.\n An operation involving parallelism.\n \n Scan rows from a table.\n For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.\n Select the first few rows based on a sort order.\n\n \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \n\n \n \n \n\n \n \n \n \n \n \n \n \n \n\n \n \n \n \n \n \n \n \n \n \n \n\n \n \n \n \n 1\n \n \n \n 0.\n \n 1\n \n 1\n \n \n \n \n \n \n\n host //*[@StatementType="COMMIT TRANSACTION"] 0 SELECT name as [schema_name] FROM master..sysdatabases 1 PostgreSQL 9.1.9 PostgreSQL \n\nCREATE USER user_#databaseName# PASSWORD '#databaseName#';\nCREATE DATABASE db_#databaseName# OWNER user_#databaseName# ENCODING 'UTF8' TEMPLATE db_template;\ncommit;\nALTER USER user_#databaseName# SET statement_timeout = 30000;\nSELECT dblink_connect('#databaseName#', 'dbname=db_#databaseName# hostaddr=127.0.0.1');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE deferred_check (id INT PRIMARY KEY)');\nSELECT dblink_exec('#databaseName#', 'INSERT INTO deferred_check VALUES (1)');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE db_#databaseName#.public.deferred_#databaseName# (fk INT NOT NULL)');\nSELECT dblink_exec('#databaseName#', 'ALTER TABLE ONLY deferred_#databaseName# ADD CONSTRAINT deferred_#databaseName#_ref FOREIGN KEY (fk) REFERENCES deferred_check(id) DEFERRABLE INITIALLY DEFERRED');\nSELECT dblink_exec('#databaseName#', 'GRANT INSERT ON deferred_#databaseName# TO user_#databaseName#');\nSELECT dblink_disconnect('#databaseName#');\n\n org.postgresql.Driver SELECT pg_terminate_backend(pg_stat_activity.procpid) FROM pg_stat_activity WHERE upper(pg_stat_activity.datname) = 'DB_#databaseName#'; DROP DATABASE db_#databaseName#;DROP USER user_#databaseName#; \N \N Separate multiple statements in PostgreSQL by terminating each one with a semicolon. 1/6ccc5/2 explain \N \N host \N 0 select datname as schema_name from pg_database 15 PostgreSQL 9.3.1 PostgreSQL \n\nCREATE USER user_#databaseName# PASSWORD '#databaseName#';\nCREATE DATABASE db_#databaseName# OWNER user_#databaseName# ENCODING 'UTF8' TEMPLATE db_template;\ncommit;\nALTER USER user_#databaseName# SET statement_timeout = 30000;\nSELECT dblink_connect('#databaseName#', 'dbname=db_#databaseName# hostaddr=127.0.0.1');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE deferred_check (id INT PRIMARY KEY)');\nSELECT dblink_exec('#databaseName#', 'INSERT INTO deferred_check VALUES (1)');\nSELECT dblink_exec('#databaseName#', 'CREATE TABLE db_#databaseName#.public.deferred_#databaseName# (fk INT NOT NULL)');\nSELECT dblink_exec('#databaseName#', 'ALTER TABLE ONLY deferred_#databaseName# ADD CONSTRAINT deferred_#databaseName#_ref FOREIGN KEY (fk) REFERENCES deferred_check(id) DEFERRABLE INITIALLY DEFERRED');\nSELECT dblink_exec('#databaseName#', 'GRANT INSERT ON deferred_#databaseName# TO user_#databaseName#');\nSELECT dblink_disconnect('#databaseName#');\n\n org.postgresql.Driver SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE upper(pg_stat_activity.datname) = 'DB_#databaseName#'; DROP DATABASE db_#databaseName#;DROP USER user_#databaseName#; \N \N \N 15/c2f73/12 explain \N \N host \N 1 select datname as schema_name from pg_database \. -- -- Name: db_types2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('db_types2_id_seq', 1, false); -- -- Name: db_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('db_types_id_seq', 15, true); -- -- Data for Name: hosts; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY hosts (id, db_type_id, jdbc_url_template, cf_dsn) FROM stdin; 1 1 jdbc:postgresql://127.0.0.1:5432/#databaseName# sqlfiddle_pg1 3 3 jdbc:jtds:sqlserver://sqlfiddlewin:1433/#databaseName# sqlfiddle_mssql1 4 4 jdbc:oracle:thin:@//sqlfiddlewin:1521/xe sqlfiddle_oracle1 5 6 jdbc:jtds:sqlserver://sqlfiddlewin:1434/#databaseName# sqlfiddle_mssql2 2 2 jdbc:mysql://sqlfiddledb2:3306/#databaseName#?allowMultiQueries=true&useLocalTransactionState=true&useUnicode=true&characterEncoding=UTF-8 sqlfiddle_mysql2 9 11 jdbc:postgresql://pg84:5432/#databaseName# sqlfiddle_pg84 10 12 jdbc:postgresql://pg92:5432/#databaseName# sqlfiddle_pg92 12 8 jdbc:mysql://my51:3306/#databaseName#?allowMultiQueries=true&useLocalTransactionState=true&useUnicode=true&characterEncoding=UTF-8 sqlfiddle_my51 11 9 jdbc:mysql://my56:3306/#databaseName#?allowMultiQueries=true&useLocalTransactionState=true&useUnicode=true&characterEncoding=UTF-8 sqlfiddle_my56 8 10 jdbc:postgresql://pg83:5432/#databaseName# sqlfiddle_pg83 13 15 jdbc:postgresql://db2:5432/#databaseName# sqlfiddle_pg93 \. -- -- Name: hosts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('hosts_id_seq', 13, true); -- -- Name: schema_defs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('schema_defs_id_seq', 589268, true); -- -- Name: user_fiddles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('user_fiddles_id_seq', 204240, true); -- -- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('users_id_seq', 5717, true); -- -- PostgreSQL database dump complete --