Re: MySQL Command Comparison

From: "Robert J(dot) Sprawls" <sprawlsr(at)worldnet(dot)att(dot)net>
To: Stephen Lawrence <logart(at)mail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MySQL Command Comparison
Date: 2000-06-24 21:15:28
Message-ID: Pine.LNX.4.20.0006241613430.4479-100000@tacdyn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 24 Jun 2000, Stephen Lawrence wrote:

SL>Has anyone posted a web page describing MySQL -> Postgresql commands?
SL>
SL>ie. In MySQL, to show all databases you type #show databases; How does
SL>Postgresql do this?
SL>
SL>Things like that. Is there a page anywhere like this?

Look at the man page for psql. In response to you example:

psql -l

will list all databases. Not sure if the user will have access to them
all, or if they are *all* the databases in the data directory.

Robert J. Sprawls sprawlsr(at)worldnet(dot)att(dot)net
Tactical Dynamics http://home.att.net/~sprawlsr
CEO (Chief Everything Officer)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Lawrence 2000-06-25 02:41:03 Re: MySQL Command Comparison
Previous Message Ross J. Reedstrom 2000-06-24 19:30:08 Re: boolean isn't boolean?