Getting exception while executing sql syntax [duplicate]

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

stackoverflow.com/questions/109325/postgresql-describe-table — Tom J Muthirenthi
– Tom J Muthirenthi, Commented Mar 12, 2017 at 17:38

Peter Gerber · Accepted Answer · 2017-03-12 17:41:23Z

1

Use this instead:

\d tblcustomer

or this for more details

\d+ tblcustomer

List available \… commands

\?

edited Mar 12, 2017 at 17:41

answered Mar 12, 2017 at 17:36

Peter Gerber

1,01710 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Shiladittya Chakraborty Over a year ago

Getting exception : ERROR: syntax error at or near "\" LINE 1: \d tblcustomer; ^ ********** Error ********** ERROR: syntax error at or near "\" SQL state: 42601 Character: 1

Peter Gerber Over a year ago

are you using the psql command line client?

Shiladittya Chakraborty Over a year ago

No. I am using postgres sql browser

Collectives™ on Stack Overflow

Getting exception while executing sql syntax [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related