postgre.rst
changeset 1700 f987c277f760
parent 1684 88f1d11d2adf
child 1701 6163ba5907d4
equal deleted inserted replaced
1699:a805ad8f6c59 1700:f987c277f760
    34 
    34 
    35   => select schema_name from information_schema.schemata;
    35   => select schema_name from information_schema.schemata;
    36   => select nspname from pg_catalog.pg_namespace;
    36   => select nspname from pg_catalog.pg_namespace;
    37   => \dn *
    37   => \dn *
    38 
    38 
       
    39 Using psql client.
       
    40 ==================
       
    41 
       
    42 Using password file ``~/.pgpass``::
       
    43 
       
    44   # comment
       
    45   hostname:port:database:username:password
       
    46   hostname:port:*:username:password
       
    47   hostname:*:*:username:password
       
    48 
       
    49 Connect by::
       
    50 
       
    51   $ psql -U $USER -h $HOST  $SCHEMA
       
    52