Les Partages de Memiks
Tag cloud
Picture wall
Daily
RSS Feed
  • RSS Feed
  • Daily Feed
  • Weekly Feed
  • Monthly Feed
Filters

Links per page

  • 20 links
  • 50 links
  • 100 links

Filters

Untagged links
2 results tagged postgresql  ✕
postgresql - How do I list all databases and tables using psql? - Database Administrators Stack Exchange https://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql
Wed Feb 27 23:56:32 2019 archive.org
QRCode
thumbnail

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

postgresql table list
the4thdoctor/pg_chameleon: MySQL to PostgreSQL replica system https://github.com/the4thdoctor/pg_chameleon/
Mon Feb 25 23:38:13 2019 archive.org
QRCode

pg_chameleon is a MySQL to PostgreSQL replica system written in Python 3. The system use the library mysql-replication to pull the row images from MySQL which are stored into PostgreSQL as JSONB. A pl/pgsql function decodes the jsonb values and replays the changes against the PostgreSQL database.

pg_chameleon 2.0 is available on pypi

postgresql mysql migration python
4759 links, including 1673 private
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn