Re: MySQL Command Comparison - Mailing list pgsql-general

From Robert J. Sprawls
Subject Re: MySQL Command Comparison
Date
Msg-id Pine.LNX.4.20.0006241613430.4479-100000@tacdyn.com
Whole thread Raw
In response to MySQL Command Comparison  (Stephen Lawrence <logart@mail.com>)
List 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@worldnet.att.net
Tactical Dynamics            http://home.att.net/~sprawlsr
CEO (Chief Everything Officer)



pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: boolean isn't boolean?
Next
From: Stephen Lawrence
Date:
Subject: Re: MySQL Command Comparison