Databases

Postgresql: show tables, show databases, show columns, describe table

Databases
July 13, 2020October 28, 2020
2 min read
Stefan Durand
11 Comments

PostgreSQL is one of the best database engines for an average web project and many who moves to psql from MySQL (for example) often ask the following questions: What is the analog of “show tables” in Postgres? How can I get the list of databases… Read More »Postgresql: show tables, show databases, show columns, describe table

PostgreSQL to File

Databases
March 21, 2012October 31, 2020
2 min read
Stefan Durand
2 Comments

PostgreSQL (or simply Postgres) is powerful and extremely popular database management system. It comes with easy to use tool that makes it possible to export output of any query into text file. If you are familiar with Mysql you may know about SELECT … INTO… Read More »PostgreSQL to File