lets say i want \d or \djs
how can i i run it :/
How to execue simple commands in dbeaver
Moderator: NorbertKrupa
-
- Newbie
- Posts: 15
- Joined: Tue Aug 26, 2014 1:43 pm
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to execue simple commands in dbeaver
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:
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.