Re: what is command to view data inside the table

From: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: what is command to view data inside the table
Date: 2005-04-11 07:34:58
Message-ID: d3d9cr$iub$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?
>
> 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;

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-04-11 09:57:19 Re: what is command to view data inside the table
Previous Message Tom Lane 2005-04-11 06:35:37 Re: Selects in Function Return Wrong Value