[Leaplist] curious about mysql vs postgres...

[Phil Barnett]

On Saturday 04 October 2008 01:01:33 pm John Simpson wrote:
> for comparison, microsoft sql provides a GUI to look at the structure,
> but if you need it programmatically (i.e. by sending a query of some
> kind) then you have to do a SELECT query against their hidden tables
> which store the information about field types and sizes.

Actually they provide well written and consistent stored procedures for this.

sp_databases lists the databases. there are hundreds of them.

http://msdn.microsoft.com/en-us/library/aa259564(SQL.80).aspx

-- 
"Ninety percent of politicians give the other 10 percent a bad name." -- Henry 
Kissinger

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.