PostgreSQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > PostgreSQL Help
Reload this Page

Show Tables Like

Discuss Show Tables Like in the PostgreSQL Help forum on Dev Shed.
Show Tables Like PostgreSQL Help forum discussing administration, SQL syntax, or other PostgreSQL-related topics. PostgreSQL provides enterprise level database functionality at open source prices.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old April 24th, 2008, 05:09 AM
vibrations vibrations is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 23 vibrations User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 54 m 55 sec
Reputation Power: 0
Show Tables Like
hi,

any alternative for mysql SHOW TABLES LIKE.... in postgres... ??
i need to get the status->[4]
or is it only 'select count(*) from ....' ??
Reply With Quote
  #2  
Old April 24th, 2008, 05:15 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,711 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 4 h 53 m 59 sec
Reputation Power: 259
If you want to list tables with a name like something use the standard information_schema.tables table, it's available in PostgreSQL, MsSQL and MySQL (from v5.x).
Start reading this article.
Reply With Quote
  #3  
Old April 24th, 2008, 05:26 AM
vibrations vibrations is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 23 vibrations User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 54 m 55 sec
Reputation Power: 0
Quote:
Originally Posted by pabloj
If you want to list tables with a name like something use the standard information_schema.tables table, it's available in PostgreSQL, MsSQL and MySQL (from v5.x).
Start reading this article.


basically i need to get the performnce eval by getting the no.of rows being inserted into various tables... the thing is that there are multiple insertion being done... so i some how want to track out the total no'of insertions.. first individually with each tab and then overalll... any help???
Reply With Quote
  #4  
Old April 24th, 2008, 05:27 AM
vibrations vibrations is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 23 vibrations User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 54 m 55 sec
Reputation Power: 0
Quote:
Originally Posted by vibrations
basically i need to get the performnce eval by getting the no.of rows being inserted into various tables... the thing is that there are multiple insertion being done... so i some how want to track out the total no'of insertions.. first individually with each tab and then overalll... any help???


multiple insertions as in.. data is simlutaneously being inserted into multiple tables.. so how can i judge the perfo. eval???
Reply With Quote
  #5  
Old April 24th, 2008, 05:37 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,711 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 4 h 53 m 59 sec
Reputation Power: 259
I don't understand your requirement
Are you trying to estimate database/table size and number of rows?
Or are you trying to compute the insertion rate of an application?
Last edited by pabloj : April 24th, 2008 at 05:40 AM.
Reply With Quote
  #6  
Old April 25th, 2008, 03:40 AM
vibrations vibrations is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2008
Posts: 23 vibrations User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 54 m 55 sec
Reputation Power: 0
Quote:
Originally Posted by pabloj
I don't understand your requirement
Are you trying to estimate database/table size and number of rows?
Or are you trying to compute the insertion rate of an application?


yes i need to find the overall insertion rate simultaneously into multiple tables...
Reply With Quote
  #7  
Old April 25th, 2008, 04:50 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,711 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 4 h 53 m 59 sec
Reputation Power: 259
Better meter it in your app.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Show Tables Like

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway.