How to execue simple commands in dbeaver

Moderator: NorbertKrupa

Post Reply
Benjamin_e
Newbie
Newbie
Posts: 15
Joined: Tue Aug 26, 2014 1:43 pm

How to execue simple commands in dbeaver

Post by Benjamin_e » Wed Oct 15, 2014 3:01 pm

lets say i want \d or \djs

how can i i run it :/

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: How to execue simple commands in dbeaver

Post by JimKnicely » Sun Oct 19, 2014 3:08 pm

Hi,

Since \d and \dj are meta-commands specific to the vsql CLI, I don't think it's possible to execute them via dBeaver.

You can make your own queries that returns the same results as the meta-commands.

For instance, for \d you can use this query:

Code: Select all

select table_schema "Schema", table_name "Name", 'table' "Kind", tables.owner_name "Owner", comment "Comment"
from tables
left join comments
on comments.object_id = tables.table_id
order by 1, 2;
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “DBeaver”