How to get next code from a table in pgsql?

Asked

Viewed 60 times

0

In Mysql I use the syntax

SHOW TABLE STATUS LIKE 'NOME_DATABELA'

How I capture the report in Postgres?

php sql postgresql pdo

  • What do you mean "next code"?

  • I don’t know what you mean by "next code" but maybe you’ll find what you’re looking for by consulting the Information Schema or the Catalogues of the system. If you are referring to an auto-increment field then see the sequence manipulation functions: https://www.postgresql.org/docs/current/functions-sequence.html

No answers

Browser other questions tagged php sql postgresql pdo

You are not signed in. Login or sign up in order to post.