Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: How can I pass number of rows value in psql table into HTML?

by psini (Deacon)
on May 19, 2008 at 19:31 UTC ( #687451=note: print w/ replies, xml ) Need Help??


in reply to How can I pass number of rows value in psql table into HTML?

SELECT count(*) FROM yourtable is much better: it is faster and avoid transferring to your program the contents of the entire table (with huge tables this can make a huge difference)

This statement return only one row, with only one integer value, which is the number of rows in yourtable


Comment on Re: How can I pass number of rows value in psql table into HTML?
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://687451]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (15)
As of 2014-08-21 21:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (143 votes), past polls