· 6 years ago · May 29, 2019, 04:46 PM
1FFFFFFFExecuting (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
2Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
3Executing (default): CREATE TABLE IF NOT EXISTS "Contacts" ("id" SERIAL , "name" VARCHAR(255), "phone" VARCHAR(255), "email" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
4Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Contacts' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
5FExecuting (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
6Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
7Executing (default): CREATE TABLE IF NOT EXISTS "Contacts" ("id" SERIAL , "name" VARCHAR(255), "phone" VARCHAR(255), "email" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
8Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Contacts' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
9FExecuting (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
10Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
11Executing (default): CREATE TABLE IF NOT EXISTS "Contacts" ("id" SERIAL , "name" VARCHAR(255), "phone" VARCHAR(255), "email" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
12Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Contacts' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
13Executing (default): INSERT INTO "Contacts" ("id","name","phone","email","createdAt","updatedAt") VALUES (DEFAULT,'Alice','001-101-1010','alice@example.com','2019-05-18 23:18:52.421 +00:00','2019-05-18 23:18:52.421 +00:00') RETURNING *;
14Executing (default): SELECT "id", "name", "phone", "email", "createdAt", "updatedAt" FROM "Contacts" AS "Contact";
15.Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
16Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
17Executing (default): CREATE TABLE IF NOT EXISTS "Contacts" ("id" SERIAL , "name" VARCHAR(255), "phone" VARCHAR(255), "email" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
18Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Contacts' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
19Executing (default): SELECT "id", "name", "phone", "email", "createdAt", "updatedAt" FROM "Contacts" AS "Contact";
20.Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
21Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
22Executing (default): CREATE TABLE IF NOT EXISTS "Contacts" ("id" SERIAL , "name" VARCHAR(255), "phone" VARCHAR(255), "email" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
23Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Contacts' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
24Executing (default): INSERT INTO "Contacts" ("id","name","phone","email","createdAt","updatedAt") VALUES (DEFAULT,'Alice','001-101-1010','email@email.com','2019-05-18 23:18:52.456 +00:00','2019-05-18 23:18:52.456 +00:00') RETURNING *;
25.Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
26Executing (default): DROP TABLE IF EXISTS "Contacts" CASCADE;
27Executing (default): CREATE TABLE IF NOT EXISTS "Contacts" ("id" SERIAL , "name" VARCHAR(255), "phone" VARCHAR(255), "email" VARCHAR(255), "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
28Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Contacts' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;