list tables in redshift using SQLWorkbench

Question

How do I list tables in redshift ?

I am using SQLWorkbench.

I tried SHOW TABLES; and \dt are not recognized commands.

Any help?

SQL Workbench also has the `WbList` command: http://www.sql-workbench.net/manual/wb-commands.html#command-list — , Aug 27 '14 at 06:40
I tried WbList, it didn't give me anything useful. Has this changed in the last ~1.5 years? — szeitlin, May 12 '16 at 20:31
@szeitlin "didn't give anything useful" isn't a usable problem description — , Mar 30 '17 at 12:11

score 8 · Answer 1 · answered May 22 '17 at 07:29

8

On Sql workbench,

Go to Tools -> New DBexplorerWindow

it will load all the tables and click on table name shown the table schema as well

Hope this is helpfull.

answered May 22 '17 at 07:29

Mukul Bhardwaj

183
1
2
8

score 2 · Accepted Answer · answered Jun 06 '14 at 04:52

2

You can use this query to get the list of tables

SELECT DISTINCT tablename
FROM pg_table_def
WHERE schemaname = 'public'
ORDER BY tablename;

More info here - http://docs.aws.amazon.com/redshift/latest/dg/c_join_PG_examples.html

answered Jun 06 '14 at 04:52

Naveen Vijay

15,928
7
71
92

1

@a_horse_with_no_name Responding to comments a year later is not helpful, either. My guess is that what I meant was, "This returned no results." But I don't remember. Because it was a year ago. – szeitlin Apr 01 '17 at 10:15

score -1 · Answer 3 · answered Jun 08 '16 at 07:35

This should work.

select datname, nspname, relname, sum(rows) as rows
from pg_class, pg_namespace, pg_database, stv_tbl_perm
where pg_namespace.oid = relnamespace
and pg_class.oid = stv_tbl_perm.id
and pg_database.oid = stv_tbl_perm.db_id
and datname = '**db_name**' and nspname = '**schema_name**'
group by datname, nspname, relname
order by datname, nspname, relname;

list tables in redshift using SQLWorkbench

3 Answers3