KrNp5f9N

1DO $$
2BEGIN
3  IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'categories')) THEN
4    CREATE TABLE IF NOT EXISTS categories
5    (
6      id   SERIAL NOT NULL,
7      name character varying(40),
8      CONSTRAINT categories_pkey PRIMARY KEY (id)
9    );
10
11    INSERT INTO categories (name) VALUES ('Games');
12    INSERT INTO categories (name) VALUES ('Multimedia');
13    INSERT INTO categories (name) VALUES ('Productivity');
14    INSERT INTO categories (name) VALUES ('Tools');
15    INSERT INTO categories (name) VALUES ('Health');
16    INSERT INTO categories (name) VALUES ('Lifestyle');
17    INSERT INTO categories (name) VALUES ('Other');
18  END IF;
19END
20$$; 
21     
22DO
23$$
24DECLARE
25BEGIN
26    IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'categories')) 
27    THEN
28        CREATE TABLE IF NOT EXISTS categories
29        (
30          id   SERIAL NOT NULL,
31          name character varying(40),
32          CONSTRAINT categories_pkey PRIMARY KEY (id)
33        );
34
35        INSERT INTO categories (name) VALUES ('Games');
36        INSERT INTO categories (name) VALUES ('Multimedia');
37        INSERT INTO categories (name) VALUES ('Productivity');
38        INSERT INTO categories (name) VALUES ('Tools');
39        INSERT INTO categories (name) VALUES ('Health');
40        INSERT INTO categories (name) VALUES ('Lifestyle');
41        INSERT INTO categories (name) VALUES ('Other');
42    END IF;
43END;
44$$  LANGUAGE PLPGSQL;