R Postgres and shortcut commands?

Question

Do postgres shortcuts like \d+ tablename work with RPostgreSQL? If I try to run 'em I get a syntax error: Error: '\d' is an unrecognized escape in character string starting "\d".

I tried escape it, but did not figure it out. RPostgreSQL itself works -- I can access and query my database.

score 6 · Accepted Answer · answered May 18 '13 at 07:19

6

No. These are "psql metacommands" and only recognised by the psql command-line interpreter. Only SQL commands can be passed through RPostgreSQL to the Postgres database.

answered May 18 '13 at 07:19

Spacedman

92,590
12
140
224

You might want to try emulating the metacommands you need via queries to the INFORMATION_SCHEMA: http://www.informit.com/articles/article.aspx?p=409471&seqNum=5 – Spacedman May 18 '13 at 08:01

R Postgres and shortcut commands?

1 Answers1