postgre query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bala r
    New Member
    • Dec 2011
    • 1

    #1

    postgre query

    1.query to retrieve the last column from the table?


    2.query to retrieve the structure of the table?
    if i am use /d command means than the below error will come
    ERROR: syntax error at or near "/"
    LINE 1: select /d errorlog
    ^

    ********** Error **********

    ERROR: syntax error at or near "/"
    SQL state: 42601
    Character: 8

    or
    if iam use \d

    ERROR: syntax error at or near "/"
    LINE 1: /d tran_1216_2216;
    ^


    ********** Error **********

    ERROR: syntax error at or near "/"
    SQL state: 42601
    Character: 1
Working...