0

I have a table that a user created which appears to be from a python variable that never interpolated.

afsproddb01=# \dt+ *transtable*
                    List of relations
 schema |      name       | type  | owner  | description
--------+-----------------+-------+--------+-------------
 public |  + transtable + | table | usiapp |
(1 row)

I am unable to drop it, I can only describe it with the \dt+ and wildcard method. Can anyone point me in the right direction?

  • I was able to answer my own question, a co worker was able to see a space in from of the first plus sign. I was not seeing this, so quoted drop worked. afsproddb01=# drop table " + transtable +"; DROP TABLE – jaysunn Jul 6 '17 at 13:34
  • You should add that as an answer and accept that answer so that your question can be marked as resolved – a_horse_with_no_name Jul 6 '17 at 14:41
1

I was able to answer my own question, a co worker was able to see a space in front of the first plus sign. I was not seeing this, so quoted drop worked.

afsproddb01=#drop table " + transtable +"; 
DROP TABLE

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.