StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWeb devs who have made the switch from MySQL, what postgresql features could you now not do without?
primarykey
Id
951325
data
AcceptedAnswerId
951368
AnswerCount
5
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-06-04T15:35:25.283
FavoriteCount
3
LastActivityDate
2009-06-10T17:59:00.313
LastEditDate
LastEditorUserId
0
OwnerUserId
66937
ParentId
0
PostTypeId
1
Score
5
ViewCount
391
LastEditorDisplayName
text
Body
<p>I'm contemplating the switch (mainly because of the more permissive license), and tend to hear a lot of Internet murmuring about how much better Postgres is than MySQL, but not many specifics. What do you do in Postgres that make you more productive, or you find elegant?</p> <p>It doesn't have to be fancy, for example some of my favorite things about MySQL include </p> <ul> <li>easy primary key incrementing with AUTOINCREMENT (having to write a generator for every table seems more of a pain than it should be for such a common requirement), </li> <li>"LIMIT,OFFSET" statements (makes for easy pagination)</li> <li>ON DUPLICATE KEY UPDATE (makes inserting/updating "many to many" tables quick and painless)</li> </ul>
Tags
<database><postgresql>
Title
Web devs who have made the switch from MySQL, what postgresql features could you now not do without?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDylan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POWeb devs who have made the switch from MySQL, what postgresql features could you now not do without?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POWeb devs who have made the switch from MySQL, what postgresql features could you now not do without?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POWeb devs who have made the switch from MySQL, what postgresql features could you now not do without?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COI haven't used Postgres but recently I've been working with Oracle after years of using MySQL exclusively. You're right, AUTOINCREMENT in MySQL rocks, it's a huge pain to have to create sequences for every table separately and then having to insert seq.nextval instead of simply using NULL to insert and increment the index!
  singulars
  PostPostId
  POWeb devs who have made the switch from MySQL, what postgresql features could you now not do without?
  UserUserId
  USJJ.
2. COIndeed you haven't used Postgres. There's a pseudo-type/syntax sugar called "SERIAL" which is as easy to use as AUTO_INCREMENT.
  singulars
  PostPostId
  POWeb devs who have made the switch from MySQL, what postgresql features could you now not do without?
  UserUserId
  USMilen A. Radev

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.