sahapasci

-- base table

-- drop table users cascade;

CREATE TABLE users (
    id             serial PRIMARY KEY,
    username       text NOT NULL UNIQUE,
    password       text,
    created_on     timestamptz NOT NULL,
    last_logged_on timestamptz NOT NULL

sahapasci

create table my_table (id integer primary key, data text);
create function my_func(id integer, data text) 
returns void
language plpgsql
as 
$$
begin
insert into my_table values (id, data);
end;
$$;

sahapasci

/*
* This query creates JSON input for AWS DMS (Data Migration Service) selection rules.
* It incluedes all schemas. 
*/

WITH rules AS (
  SELECT
      format('{
        "rule-type": "selection",
        "rule-id": "%s",