--
john
Sometime in June Willie Northway assaulted keyboard and produced...
|
|Hello, I'm a mysql user who's trying to learn postgres. How would I
|explore which databases or tables are available for use?
|
|If I were using mysql, I would try something like this:
|
|mysql> show databases;
|mysql> use test;
normally when postgres is started you tell it the database.
so it looks something like
psql dbname
then to show the tables
dbname=# \d
will list all the tables, sequences, etc in a "more" fashion
then to get info about a table just type
dbname=# \d table
this will give you a list of the columns and datatypes.
i dont know how to list the available databaes.
i hope this helps.
|mysql> show tables;
|
|How would I accomplish something like this in postgres?
|
|- Willie
|
|----
|Willie Northway - Software Developer http://www.willienorthway.com/
|Diamond Bullet Design - http://www.diamondbullet.com
|
|
|---------------------------(end of broadcast)---------------------------
|TIP 6: Have you searched our list archives?
|
|http://www.postgresql.org/search.mpl
|