Re: what is command to view data inside the table

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: <joseph(at)ciphercom(dot)net>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: what is command to view data inside the table
Date: 2005-04-11 09:57:19
Message-ID: 32c56326f39d9c2034672b17f97172db@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Apr 5, 2005, at 3:27 AM, jo . wrote:

> Hi,
>
> I just have a simple question... I have a database named "ibs" and I
> have table named "users"...how can I see what data are inside the
> "users" table?
>

If I understand what you are asking, you want to do a SQL select:

SELECT * FROM users;

If that is what you are asking, then I would suggest you pick up a book
on SQL. There is a good manual for postgresql at:

http://www.postgresql.org/docs/current/static/

but it is going to assume some understanding of the SQL language.

If that wasn't what you were asking, could you clarify a bit?

Sean

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-04-11 10:02:00 Re: Mac Gui
Previous Message stig erikson 2005-04-11 07:34:58 Re: what is command to view data inside the table