CREATE TABLE "access" (
	"s_in" character varying(256) NOT NULL,
	"s_out" character varying(256) NOT NULL,
	Constraint "access_pkey" Primary Key ("s_in")
);

CREATE TABLE "aliases" (
	"s_in" character varying(256) NOT NULL,
	"s_out" character varying(256) NOT NULL,
	Constraint "aliases_pkey" Primary Key ("s_in")
);

CREATE TABLE "virtualusers" (
	"s_in" character varying(256) NOT NULL,
	"s_out" character varying(256) NOT NULL,
	Constraint "virtualusers_pkey" Primary Key ("s_in")
);

CREATE TABLE "mailertable" (
	"s_in" character varying(256) NOT NULL,
	"s_out" character varying(256) NOT NULL,
	Constraint "mailer_pkey" Primary Key ("s_in")
);


CREATE TABLE "domaintable" (
	"s_in" character varying(256) NOT NULL,
	"s_out" character varying(256) NOT NULL,
	Constraint "domaintable_pkey" Primary Key ("s_in")
);

CREATE TABLE "genericstable" (
	"s_in" character varying(256) NOT NULL,
	"s_out" character varying(256) NOT NULL,
	Constraint "generics_pkey" Primary Key ("s_in")
);

CREATE TABLE "hostnamestable" (
	"s_in" character varying(256) NOT NULL,
	Constraint "hostnames_pkey" Primary Key ("s_in")
);

CREATE FUNCTION get_domains() RETURNS varchar AS '
DECLARE
	rec RECORD;
	list varchar;
BEGIN
	list := '''';
	FOR rec IN SELECT s_in FROM hostnamestable LOOP
	    list :=  list ||  rec.s_in || ''\n'';
	    END LOOP;
	    RETURN list;
END;
' LANGUAGE plpgsql;