MySQL Command Comparison

Started by Stephen Lawrencealmost 26 years ago5 messagesgeneral
Jump to latest
#1Stephen Lawrence
logart@mail.com

Has anyone posted a web page describing MySQL -> Postgresql commands?

ie. In MySQL, to show all databases you type #show databases; How does
Postgresql do this?

Things like that. Is there a page anywhere like this?

-
Stephen Lawrence Jr.
logart@dairypower.com

#2Robert J. Sprawls
sprawlsr@worldnet.att.net
In reply to: Stephen Lawrence (#1)
Re: MySQL Command Comparison

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)

#3Stephen Lawrence
logart@mail.com
In reply to: Robert J. Sprawls (#2)
Re: MySQL Command Comparison

I was kinda hoping for a web page somewhere that would have a comparison
table of all MySQL/PostgreSQL commands or something.

-
Stephen Lawrence
logart@mail.com

----- Original Message -----
From: "Robert J. Sprawls" <sprawlsr@worldnet.att.net>
Sent: Saturday, June 24, 2000 2:15 PM
Subject: Re: [GENERAL] MySQL Command Comparison

Show quoted text

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.

#4lincy lin
lincy@iname.com
In reply to: Stephen Lawrence (#3)
More OO Support

Hi !

I am new comer to PostgreSQL. I have few years experience of OODB (CA-Jasmine). It's is possible to give PostgreSQL more oo support in future release ? If PostgreSQL can support method and collection will very helpful.

I hope the mail-list was the correctly place to post wish list.

Lincy.

#5The Hermit Hacker
scrappy@hub.org
In reply to: lincy lin (#4)
Re: More OO Support

On Sun, 25 Jun 2000, lincy lin wrote:

Hi !

I am new comer to PostgreSQL. I have few years experience of
OODB (CA-Jasmine). It's is possible to give PostgreSQL more oo support
in future release ? If PostgreSQL can support method and collection
will very helpful.

there is a mailing list setup (pgsql-hackers-oo@postgresql.org) for the
express purpose of discussing developments related to OO implementations
and extensions ... Chris Bitmead has been doing alot of work on improving
this ... if you are willing/able to help him out with coding, would
recommend joining the above list and offering to help out ... even ideas
and suggestions are welcome, doesn't have to all be code :)