Getting exception while executing sql syntax

Question

describe syntax is not working in PLSql :

I am using below syntax :

DESCRIBE tblcustomer;

I am getting below exception after executing above query :

ERROR:  syntax error at or near "DESCRIBE"
LINE 1: DESCRIBE tblcustomer;
        ^

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

ERROR: syntax error at or near "DESCRIBE"
SQL state: 42601
Character: 1

http://stackoverflow.com/questions/109325/postgresql-describe-table — Tom J Muthirenthi, Mar 12 '17 at 17:38
Where in [the manual](http://www.postgresql.org/docs/current/static/index.html) did you find `describe`? — a_horse_with_no_name, Mar 12 '17 at 18:34

Peter Gerber · Answer 1 · 2017-03-12T17:41:23.143

1

Use this instead:

\d tblcustomer

or this for more details

\d+ tblcustomer

List available \… commands

\?

edited Mar 12 '17 at 17:41

answered Mar 12 '17 at 17:36

Peter Gerber

1,003
10
13

Getting exception : ERROR: syntax error at or near "\" LINE 1: \d tblcustomer; ^ ********** Error ********** ERROR: syntax error at or near "\" SQL state: 42601 Character: 1 – Shiladittya Chakraborty Mar 12 '17 at 17:41
are you using the `psql` command line client? – Peter Gerber Mar 12 '17 at 17:43
No. I am using postgres sql browser – Shiladittya Chakraborty Mar 12 '17 at 17:47

Getting exception while executing sql syntax

1 Answers1