Tag Archives: mysql

Show Databases, Tables and Columns in PostgreSQL

Posted by

Posted on

March 8, 2013

Posted under

Computers

Comments

0 Comments

Man….why is it that every time I stop using PostgreSQL for more than a month I immediately forget how to list tables and columns? Here’s a listing for posterity.

Show Databases

MySQL:

SHOW DATABASES;

PostgreSQL

\l

Show Tables

MySQL:

SHOW TABLES;

PostgreSQL

\d

Show Columns

MySQL:

SHOW COLUMNS;

PostgreSQL

\d+ tablename

Show Yourself Out (exit)…

Continue reading: Show Databases, Tables and Columns in PostgreSQL

Output a Postgres or MySQL Query to CSV

Posted by

Posted on

August 2, 2012

Posted under

Computers

Comments

0 Comments

I find myself needing to output CSV from database queries a lot, and like an Alzheimer’s patient I am constantly forgetting how to do it. Here’s the quick run-down on how you get queries from your database into a CSV file.

Postgres

\f ','
\a
\t
\o /tmp/output.csv
SELECT column_id, column_name FROM table_name;
\o
\q

Continue reading: Output a Postgres or MySQL Query to CSV