Re: doubt about the database

On Sun, 2004-09-26 at 01:49, maridu h.s.n.v.prasad wrote:
> subscribe
> end
>
> hai sir
>  i am using the postgresql 7.2 my doubt is
> what is the command of to see the list of databases
>  i create a database named "jntuoes"
>  database created it's displayed
> but i want to know the command
> so please give me the replay

in psql, you use \l

smarlowe=> \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 blog      | smarlowe | SQL_ASCII
 postgres  | postgres | SQL_ASCII
 smarlowe  | smarlowe | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
(5 rows)

If you want to execute a command to see it from SQL (i.e. an application
etc...) you can find the queries psql uses by starting it with the -E
switch, like so:

[smarlowe@localhost smarlowe]$ psql -E
Welcome to psql 7.4.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

smarlowe=> \l
********* QUERY **********
SELECT d.datname as "Name",
       u.usename as "Owner",
       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
FROM pg_catalog.pg_database d
  LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
**************************

        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 blog      | smarlowe | SQL_ASCII
 postgres  | postgres | SQL_ASCII
 smarlowe  | smarlowe | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
(5 rows)

Hope that helps.