Realtime subscriptions and comments are missing in migra diff

[chatch]

Describe the bug Running the diff with --use-pgadmin fails I can't see what's gone wrong.

To Reproduce Steps to reproduce the behavior:

1. supabase db diff --use-pgadmin

Expected behavior Diff produced.

Desktop (please complete the following information):

• OS: Ubuntu 20.04
• Browser (if applicable): N/A
• Version of CLI: 1.110.1
• Version of supabase-js (if applicable): N/A
• Version of Node.js (if applicable): N/A (installed with brew)

Additional context Error from the CLI without debug is:

⢿ Diffing local database with current migrations...

error running container: exit 1
Try rerunning the command with --debug to troubleshoot the error.

Then running with --debug i see:

2023/11/08 04:25:51 Sent Header: Host [api.moby.localhost]
2023/11/08 04:25:51 Sent Header: User-Agent [Docker-Client/unknown-version (linux)]
⣯ Diffing local database with current migrations...
2023/11/08 04:25:51 Recv First Byte
error running container: exit 1

I'm not sure how I can capture the container logs before the container is removed but that would likely show what's happening ...

[sweatybridge]

Is there any reason you want to use pgadmin instead of migra? We haven't been maintaining the pgadmin cli for a long time now.

[chatch]

I wanted to see if it picked up more schema changes than the migra diff does.

In particular we don't see comments in the diffs (on tables and other postgres objects). Don't see realtime subscriptions either. I forget the statements but there are a couple of lines we need to hand code in but it would be nice if the diff picked them up. I thought pgadmin diff might do ...