Thread: what is command to view data inside the table

what is command to view data inside the table

From
"jo ."
Date:
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
areinside the "users" table? 

thanks


---------------------------------
Get Your free Email at http://mail.ciphercom.net
Powered by AEBC Servers

Re: what is command to view data inside the table

From
Sean Davis
Date:
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


Re: what is command to view data inside the table

From
stig erikson
Date:
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
dataare inside the "users" table? 
>
> thanks
>
>
> ---------------------------------
> Get Your free Email at http://mail.ciphercom.net
> Powered by AEBC Servers
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>


if you are connected to the database you can do
SELECT * FROM users;