Contents

create language "plpythonu";

drop schema if exists prestogres_catalog cascade;

create schema prestogres_catalog;

create or replace function prestogres_catalog.run_presto_as_temp_table(
    "server" text,
    "user" text,
    "catalog" text,
    "schema" text,
    "table_name" text,
    "query" text)
returns void as $$
import prestogres
prestogres.run_presto_as_temp_table(server, user, catalog, schema, table_name, query)
$$ language plpythonu;

create or replace function prestogres_catalog.run_system_catalog_as_temp_table(
    "server" text,
    "user" text,
    "catalog" text,
    "schema" text,
    "table_name" text,
    "query" text)
returns void as $$
import prestogres
prestogres.run_system_catalog_as_temp_table(server, user, catalog, schema, table_name, query)
$$ language plpythonu;

create or replace function prestogres_catalog.create_schema_holders("count" int)
returns void as $$
import prestogres
prestogres.create_schema_holders(count);
$$ language plpythonu;

create or replace function prestogres_catalog.create_table_holders("count" int)
returns void as $$
import prestogres
prestogres.create_table_holders(count);
$$ language plpythonu;

select prestogres_catalog.create_schema_holders(512);

select prestogres_catalog.create_table_holders(2048);

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
prestogres-0.4.7	pgsql/setup.sql
prestogres-0.4.6	pgsql/setup.sql
prestogres-0.4.5	pgsql/setup.sql
prestogres-0.4.4	pgsql/setup.sql
prestogres-0.4.3	pgsql/setup.sql
prestogres-0.4.2	pgsql/setup.sql
prestogres-0.4.1	pgsql/setup.sql
prestogres-0.4.0	pgsql/setup.sql