1

I tried \ds didn't get any relations data.

But I use SELECT * FROM information_schema.sequences; can get all the data.

Why doesn't \ds work?

0
4

\ds without argument doesn't show sequences that are not accessible through the current search_path, whereas information_schema.sequences ignores the search path.

On the other hand, information_schema.sequences won't show sequences that the current user cannot actually use, whereas \ds won't filter those out. According to the documentation:

Only those sequences are shown that the current user has access to (by way of being the owner or having some privilege).

To see all sequences in psql, try:

\ds *.*

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.