Database |> Postgres |> 

dblink

Contents

High Level

Since LSD is Postgres compatible, you can directly load data into an existing Postgres database with the dblink method.

CREATE EXTENSION IF NOT EXISTS dblink;

SELECT
  *
INTO TABLE lsd
FROM dblink('host=lsd.so dbname=<email> password=<api key>',
                '<LSD SQL>')
      AS t1(<column identifiers>);

Tutorial

Coming soon.


Related: