Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Italy
    Posts
    36

    Wink Unanswered: Counting Tables In Visual Basic

    How can i do to count tables on a postgreSQL tables...

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    ???

    counting tables on a postgresql table ???
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    if you mean just count the tables here is the sql. I have no idea how to do it from VB however.

    select count(tablename) from pg_tables where tablename not like 'pg%';

    This is assuming that you do not name your tables with the pg_ abbreviation like the postgres system tables.....but who would go do a silly thing like that

  4. #4
    Join Date
    May 2002
    Location
    Italy
    Posts
    36
    tnx!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •