[Gllug] Why not to use MySQL...

[Sean Burlington]

Peter Childs wrote:
> 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
> 

thanks - that looks very useful

although

"The information schema views do not, however, contain information about 
PostgreSQL-specific features"

which could be a bit of a gotcha - I've never seen a live database that 
didn't use SQL extensions

-- 

Sean



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