Thread: MySQL Command Comparison
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
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)
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.
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.
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 :)