"select * from groupes" didn't display any data

[lise chhay]

I executed the script inst/creer-base, the script run, because when I did :
$ psql auth
auth=# \dt
List of relations
Schema | name | Type | Owner
-------------------------------------------------
public | config | table | postgres
public | groupes | table | postgres
public | membres | table | postgres
public | utilisateurs | table | postgres

auth=# \q

But, when I executed the script inst/init-base, that script didn't run, as you can see :
$ psql auth
auth=# \encoding latin9
auth=# select * from groupes
auth=#

"select * from groupes" didn't display any data. Can you help me. I work under Mandrake

Thanks
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Tom Lane]

Post by lise chhay
$ psql auth
auth=# \encoding latin9
auth=# select * from groupes
auth=#
"select * from groupes" didn't display any data.

I think you forgot to type a semicolon?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Chris Gamache]

I need an informed opinion:

The performance boost from clustering is wonderful. But, some tables would have
to clustered several times a day, since there is usually some type of "status"
column that is updated pretty regularly. Clustering is an expensive operation.
If I pulled out that column into another "child" table and linked the tables by
a foreign key to the "parent" I could update the "child" table and it wouldn't
foul up the master table's ordering at all. Create a view on the two tables,
and I'd have a relatively-stable setup as far as ordering goes, yes?

Is this adviseable? In the long-run, will it yield the results that I expect?
Did I miss any details? Should I be looking for any pitfalls?

CG




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Naomi Walker]

Post by lise chhay
$ psql auth
auth=# \dt
List of relations
Schema | name | Type | Owner
-------------------------------------------------
public | config | table | postgres
public | groupes | table | postgres
public | membres | table | postgres
public | utilisateurs | table | postgres
auth=# \q
$ psql auth
auth=# \encoding latin9
auth=# select * from groupes
auth=#
"select * from groupes" didn't display any data. Can you help me. I work under Mandrake
Thanks

I think you forgot the closing semicolon. Try:

Select * from groupes;

It didn't know you were done typing.
--
-------------------------------------------------------------------------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc. ***@eldocomp.com 602-604-3100
-------------------------------------------------------------------------
Thought is the blossom; language the bud; action the fruit behind it.
- Ralph Waldo Emerson
-------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend