diff options
Diffstat (limited to 'sql/quantifi.sql')
| -rw-r--r-- | sql/quantifi.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/quantifi.sql b/sql/quantifi.sql index 1191c589..17fe1d95 100644 --- a/sql/quantifi.sql +++ b/sql/quantifi.sql @@ -1,3 +1,4 @@ + CREATE TABLE bespokes ( "date" date NOT NULL, "row" int8 NOT NULL, @@ -318,3 +319,5 @@ CREATE TABLE swaptions ( CONSTRAINT qf_swaptions_pk PRIMARY KEY (date, "row") ); + CREATE SERVER dawndb_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'dawndb'); + CREATE USER MAPPING FOR quantifi_user SERVER dawndb_server OPTIONS (user 'dawn_user', password '****'); |