Thread: MySQL Command Comparison

MySQL Command Comparison

From
Stephen Lawrence
Date:
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



Re: MySQL Command Comparison

From
"Robert J. Sprawls"
Date:
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)



Re: MySQL Command Comparison

From
Stephen Lawrence
Date:
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


>
> 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.



More OO Support

From
"lincy lin"
Date:
Hi !


    I am new comer to PostgreSQL. I have few years experience of OODB (CA-Jasmine). It's is possible to give PostgreSQL
moreoo 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.

Re: More OO Support

From
The Hermit Hacker
Date:
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 :)