Re: [GENERAL] basic postgres questions...

2007-05-19 Thread woodb
> hey.. . > > can someone point me to the cmds that i'd use in order to see what > databases > are created in my postgres app. i need to see what's here, and then i need > to know the cmd to then delete a given database, and the underlying > tables. from the OS command line, psql -l will list the

Re: [GENERAL] Views- Advantages and Disadvantages

2007-05-09 Thread woodb
> On 5/9/07, Ashish Karalkar <[EMAIL PROTECTED]> wrote: > > Hello All, > Can anybody please point me to Advantages and Disadvantages > of using view Hi Ashish, There are several, but they are generally about implementing a more user friendly database from a well normalised structure. You can us

Re: [GENERAL] Advantages of PostgreSQL over MySQL 5.0

2006-03-23 Thread woodb
> > Hello there, > I'm a freelance Oracle Developer by trade (can almost hear the boos now > ;o)), and am looking into developing my own Snowboarding-related > website over the next few years. Anyway, I'm making some decisions now > about the site architecture, and the database I'm going to need is

Re: [GENERAL] Data type to store latitude and longitude

2005-07-14 Thread woodb
> Hi guys, > > Is there a data type to store data extracted from a > GPS? The only thing I need is store latitude and > longitude. > > Thanks in advance, > There are a few options, Using basic Postgresql: store the lats as +-90 & longs as 0-360 or +-180 numeric datatypes. create a numeric array