how to select

From: "Jonathan Villa" <jvilla(at)innovativesource(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: how to select
Date: 2005-07-29 18:18:56
Message-ID: 24238.216.125.144.21.1122661136.squirrel@mail.innovativesource.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Ok, I should be posting this to the kindergarden list... but I didn't subscribe...

I've connected to a database

psql -l testdb

showed tables
\d

show table schema
\d testtable

now I want to select
#select someColumn from testtable

I get nothing... no output, nothing...

I'm used to MySQL where I can queries once connected... I'm sure I can do the same
with PGSQL...

FYI, I'm also using phpPGAdmin and I can run the SQL query there just fine

-Jonathan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edmund Dengler 2005-07-29 18:23:29 Re: Failure to use indexes
Previous Message Brian Wong 2005-07-29 18:15:33 Re: how to select