Skip to content

Instantly share code, notes, and snippets.

@RaulMedeiros

RaulMedeiros/list tables of a postgres database inside a container

Created July 9, 2020 13:35
Show Gist options
  • Save RaulMedeiros/b97c55899293755f9e0f990aaf42e145 to your computer and use it in GitHub Desktop.
Save RaulMedeiros/b97c55899293755f9e0f990aaf42e145 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
list tables of a postgres database inside a container
docker exec -i container_id psql -U postgres -c "
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY table_name;
"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment