DEV Community

udomsak
udomsak

Posted on

1

NOTE-What is Sequence use in Postgresql

A sequence is a special kind of database object designed for generating unique numeric identifiers. It is typically used to generate artificial primary keys. Sequences are similar, but not identical, to the AUTO_INCREMENT concept in MySQL.

Thai

Sequence คือ Database object ใน PostgreSQL ปกติใช้ในการ generate key ( ใช้สำหรับ primary keys ) Sequence จะว่าไปก็คล้ายๆ กับ Auto-increment ใน MySQL.

หมดปัญหาไปเรื่อง Key ชนกัน เพราะ Sequence ออกแบบมาเพื่อการนี้อยู่แล้ว

Link : http://www.neilconway.org/docs/sequences/

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay