> For the complete documentation index, see [llms.txt](https://til.duyet.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.duyet.net/db/aws-redshift-postgres/redshift-tables-and-their-owners.md).

# 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>