#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13

    Arrow How see the tables in a users schema ??


    Hi

    I've connected to psql and created a table. How do I see the tables in this schema now ??

    If I may compare my question with Oracle, I accomplish this using

    Code:
    select * from tab;
    So also, how do I do this in PostgreSQL ??

    Thanks & Regards.
  2. #2
  3. #3
  4. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13
    Hi

    Thanks for your help. The link lists the following ...

    \d{t|i|s|v} list tables/indices/sequences/views

    But when I give this it says ...


    hris=> \d{t|i|s|v}
    Did not find any relation named "{t|i|s|v}".
    hris=>
    So, how do I go about this ??

    Thanks & Regards.
  5. #4
  6. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13
    Hi

    I got it !!

    Big Thanks to you !!!


    hris=> \d
    List of relations
    Name | Type | Owner
    ------+-------+--------
    t | table | u_hris
    (1 row)

    hris=>

    Regards.

IMN logo majestic logo threadwatch logo seochat tools logo