[Gllug] Why not to use MySQL...

[Sean Burlington]

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 ?

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)

-- 

Sean


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