Knowledge Base Contributions

Below is a list of the knowledge base entries that Jonathan Ellis has contributed to:

• How do you get the id generated by a SERIAL field in a previous query (like mysql _insert_id)?
  

• Using SEQUENCE WRAP/nextval can auto gen. a unique id. How do I reuse id's of del. rec's on wrap.
  

• We have no backup facilities for our PostgeSQL DB server. What can we use as a backup facility? How can we restore a single table of a DB?
  

• about date comparison
  

• How can I limit the number of records returned by PostgreSQL ?
  

• How can I do a case insensitive search query in Postgres?