What are PostgreSQL PGSQL commands for showing all databases / table details in my machine, like MySQL has show databases & describe tablename?

Thank you for your time.

"\l" followed by enter shows all dbs
"\d followed by enter shows all tables in the current db

"\?" followed by enter shows all the availabe slash commands

Thanks m0rl0ck. That's it.

Hey if youve got apache and php phppgadmin gives you a nice web interface to postgres:

http://phppgadmin.sourceforge.net/

Its what I usually use, its dependable.

hi,
I am new to postgresql,
I install it with rpm (red8.0), i create database and user, that ok. when I wnat to connect from another site ( or in the same machine with precising the server i doesn't find it.
I didn't give any server name to the postgres, where to do it , what is the name by default

this is the example :

[bela@info-50 bdEtud]$ psql etudiant -h localhost
psql: could not connect to server: Connection refused
Is the server running on host localhost and accepting
TCP/IP connections on port 5432?
[bela@info-50 bdEtud]$

If I omit -h localhost it runs correctly

thanks

is it running on port 5432?

the output of:
"netstat -pant | grep post"

Should have in it:
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 1103/postmaster


If it doesnt you need to make sure that pg_ctl is starting postmaster with the "-i" flag.

here is the line I use to start postgres exactly as it appears in my init script:

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -o "-i" -D $PGDATA -p /usr/bin/postmaster start> /dev/null 2>&1" < /dev/null

Also take a look at your pg_hba.conf file with an eye to security. As with any service that opens a port you need to take some precautions. Depending on how much use the server gets you might also need to increase the amount of shared memory allocated too.