Daily Weekly Monthly

Daily Shaarli

All links of one day in a single page.

February 27, 2019

postgresql - How do I list all databases and tables using psql? - Database Administrators Stack Exchange

Please note the following commands:

\list or \l: list all databases
\dt: list all tables in the current database

You will never see tables in other databases, these tables aren't visible. You have to connect to the correct database to see its tables (and other objects).

To switch databases:

\connect database_name or \c database_name

http://www.postgresql.org/docs/current/interactive/app-psql.html

SUSI AI

Susi AI is an intelligent Open Source personal assistant. It is capable of chat and voice interaction and by using APIS to perform actions such as music playback, making to-do lists, setting alarms, streaming podcasts, playing audiobooks, and providing weather, traffic, and other real time information. Additional functionalities can be added as console services using external APIs. Susi AI is able to answer questions and depending on the context will ask for additional information in order to perform the desired outcome. The core of the assistant is the Susi AI server that holds the “intelligence” and “personality” of Susi AI. The Android and web applications make use of the APIs to access information from a hosted server.

An automatic deployment from the development branch at GitHub is available for tests here https://susi-server.herokuapp.com