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] basic postgres questions...

2007-05-17 Thread Shane Ambler
Ray Stell wrote: On Wed, May 16, 2007 at 08:21:59AM -0700, bruce wrote: 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

[GENERAL] basic postgres questions...

2007-05-16 Thread bruce
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. in searching google, i'm seeing different cmds... also, is

Re: [GENERAL] basic postgres questions...

2007-05-16 Thread Ray Stell
On Wed, May 16, 2007 at 08:21:59AM -0700, bruce wrote: 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 template1=# select datname, oid from pg_database; datname | oid