# Redshift - tables and their owners

It was pg\_tables table and here is the SQL:

```sql
SELECT tablename, tableowner FROM pg_tables;
```

Source: <https://stackoverflow.com/a/29861410>