Skip site navigation (1) Skip section navigation (2)

view database, tables, columns

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: view database, tables, columns
Date: 2008-01-27 09:24:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I've created a database. I couldn't find any documentation to help me
with the following questions.

How do I see a list of the names of databases that I've created?
How do I see the name of the table(s) of a database?
How do I see the names of columns within a table?

I can see the information using the program pgadmin 3, but I want to
learn how to see this information from the command terminal.


postgresql 826
mandriva 2007



pgsql-novice by date

Next:From: A. KretschmerDate: 2008-01-27 09:54:25
Subject: Re: view database, tables, columns
Previous:From: Jaime CasanovaDate: 2008-01-27 02:20:14
Subject: Re: Indexes to speed sorting

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group