Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://687451]
[Corion]: Actually bsd_glob '{www.,}perlmonks .{com,net,org}', plus I think
[Corion]: Sad that Let's Encrypt does not allow wildcard certificates, but they could be somewhat of a hassle to verify
[Discipulus]: since 2002 I just usewd and good morning
Discipulus .oO(maybe a PM discussion?)

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (8)
As of 2017-09-26 07:52 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (292 votes). Check out past polls.