Text in PostgreSQL

Handling text in PostgreSQL (but not Natural Language).

• Videos

  • Text in Databases
  • Text Functions
  • Character Sets
  • Character Sets in Python
  • Inside Hashes
  • Index Choices and Techniques
  • Regular Expressions
  • Using Regular Expressions
  • Demonstration: Generating and Scanning Text
  • Demonstration: Regular Expressions
  • Demonstration: Flat files, Regex, Email

• Slides

  • 04-Text.pptx

• References

  • Sample SQL For Lecture
  • Regular Expression Handout
  • High Contrast / Printable Slides
• Discussions:
  • Text in PostgreSQL (Login Required)
    
• Tools:
  • Quiz: Text in PostgreSQL (Login Required)
    
  • Autograder: Creating a Stored Procedure (Login Required)
    
  • Autograder: Regular Expressions (Login Required)
    
  • Autograder: Generating Text (Login Required)
    
  • Puzzle: Break a Hashing Function (Login Required)