PostgreSQ MySQL  | July 2013

DATA SERVER | ORDBMS | PRODUCTION | Gene Casanova, Senior Database Developer | EXPERIMENTAL


Bookmark and Share
DATABASE MIGRATION SERVICES | DATA ENTRY | DATA PROCESSING PROGRAMMING | CROSS-PLATFORM INTEGRATION
INTERNET / EXTRANET / INTRANET - BACKEND/ FRONTEND WEB APP/WEB SITE/E-COMMERCE DEV
SMALL BUSINESS / MEDIUM BUSINESS DATABASE ADMINSTRATION | ENTERPRICE DATABASE DEVELOP & DEPLOYMENT SOFTWARE & HARDWARE
CUSTOM BUILD WORLD-STANDARD HARDWARE COMMERCIAL-INTERNET & BUSINESS CLASS SERVERS & OEM PARTS

PostgreSQL Database MySQL To PostgreSQL Commands

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

How Do I Do A MySQL Command On A PostgreSQL Database?

Typical MySQL administrator questions.  Typical MySQL migration tasks. Below are the translations.

When using the PostgreSQL client "psql", enter the command " \?" for a list of currently-available PostgreSQL commands on the specific PostgresSQ-server curently-connected to.

Translation

PostgreSQL MySQL Command Cross Reference

mysql : SHOW TABLE
postgresql : \d
postgresql SQL : SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

mysql : SHOW DATABASE
postgresql : \l
postgresql SQL : SELECT datname FROM pg_database;

mysql : SHOW COLUMNS
postgresql : \d table
postgresql SQL : SELECT column_name FROM information_schema.columns WHERE table_name ='table';

mysql : DESCRIBE TABLE
postgresql : \d+ table
postgresql SQL : SELECT column_name FROM information_schema.columns WHERE table_name ='table';


Intended For Internal Private Use.  Use At Your Own Risk. ©2013 Copyright Gene Casanova.