Other SQL clients
NOTE: This is an
sgr-specific article. To learn how to use Splitgraph with
your database client, see the
corresponding Splitgraph page.
sgr engine is a PostgreSQL instance, most SQL clients will be able
to connect to it and read/write to checked out Splitgraph tables without issues.
You can use
sgr config -n
to print out a libpq connection string used by the current engine that you can paste into your client. For example:
pgcli $(sgr config -n)
will run pgcli against the default engine.
Note that since
layered querying using PostgreSQL foreign
tables, some tools might not show them in the list of tables or show them in a
different list of foreign tables. However, in most cases, you should still be
able to query them in the same way as normal tables.