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.

Since the 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 sgr implements 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.