[Gllug] Why not to use MySQL...

[Peter Childs]

Sean Burlington wrote:

> Peter Childs wrote:
>
>>
>> On Tue, 25 Nov 2003, Richard Jones wrote:
>>
>>
>>> On Tue, Nov 25, 2003 at 11:40:14AM +0000, Sean Burlington wrote:
>>>
>
>>> SHOW CREATE TABLE - I have no idea what this could do.
>>>
>>> SHOW TABLES - Probably the \d or \dt commands in psql which list
>>> relations and tables respectively.
>>
>>
>>
>>     With Postgres 7.4 you can use the sql standard scehma for viewing
>> tables. Which is probably a better way of doing it than *any* other
>> database.
>>
>
> I can't find this in the docs - have you a url handy ?
>

    Its probably such a new feature that the docs ain't been finished. 
Bad news really. I've not tested it my self but

http://www.postgres.org/docs/current/interactive/information-schema.html

    Seams to have been added to the manual.

> thanks to everyone for the tips - it looks like postgress can do 
> everything I need so long as I change the syntax of a few queries.
>
> part of the problem seems to stem from the incompletenes of SQL as a 
> standard - some things (like LIMIT and serial) are implemented by most 
> db servers despite not being a part of standard SQL (but all used 
> differently)
>
    I don't disagree for a standard SQL is useless...

Peter Childs


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug