Importing a postgres schema from RDS in CQL

[chri...@begroup.io]

I am trying to import my public schema from a postgres RDS database cluster into the CQL IDE.

I've tried all of these connection string options in a .cql file and none of them works.  I'm especially confused because the last two seem to be exactly the example format given in the docs here: http://categoricaldata.net/help/schemaimport_jdbc_all.html

schema "-h postg-dev.clsioxywxvnr.us-east-2.rds.amazonaws.com -U username -d DatabaseName" = sql

schema import_jdbc_all  "-h postg-dev.clsioxywxvnr.us-east-2.rds.amazonaws.com -U username -d DatabaseName" : sql

schema (import_jdbc_all  "-h postg-dev.clsioxywxvnr.us-east-2.rds.amazonaws.com -U username -d DatabaseName") : sql

schema (import_jdbc_all  "psql -h postg-dev.clsioxywxvnr.us-east-2.rds.amazonaws.com -U username -d DatabaseName") : sql

Does anyone have an idea of what I am doing wrong?

EDIT:

These are the errors they produce, respectively:

Syntax error: org.jparsec.error.ParserException: line 1, column 98:
= expected, : encountered.

Syntax error: org.jparsec.error.ParserException: line 1, column 8:
string literal, INTEGER or IDENTIFIER expected, import_jdbc_all encountered.

Syntax error: org.jparsec.error.ParserException: line 1, column 8:
string literal, INTEGER or IDENTIFIER expected, ( encountered.

Syntax error: org.jparsec.error.ParserException: line 1, column 8:
string literal, INTEGER or IDENTIFIER expected, ( encountered.

[Ryan Wisnesky]

Hello,

The string given to the JDBC operations needs to be a JDBC string, i.e., you must load the postgres JDBC driver on the CQL class path, and use the JDBC string described here:

https://jdbc.postgresql.org/documentation/head/connect.html

This process is explained more in depth in this example:

http://cql.conexus.ai/sql.php

Do please let me know if that solves your issue.

Regards,

Ryan