Skip to content

Instantly share code, notes, and snippets.

View augnustin's full-sized avatar
😊

Augustin Riedinger augnustin

😊
View GitHub Profile
View remote_select
CREATE OR REPLACE FUNCTION remote_db(_table anyelement)
RETURNS SETOF anyelement
AS $func$
DECLARE
_host text := 'ngrok.com'
_port text := '53813'
_user text := 'postgres'
_password text := 'postgres'
_db_name text := 'backup-28-08'
_server text := format('host=%s port=%s user=%s password=%s dbname=%s', _host, _port, _user, _password, _db_name);