PostgreSQL Connection URI Regex Pattern
Validates PostgreSQL connection strings (postgres:// or postgresql://).
Pattern
^postgres(?:ql)?:\/\/(?:[^:@\/\s]+(?::[^@\/\s]*)?@)?[^:\/\s]+(?::\d+)?(?:\/[^\s?]+)?(?:\?\S*)?$Tested examples
postgres://user:pass@localhost:5432/mydbpostgresql://localhost/mydbpostgresql://[email protected]:5432/app?sslmode=requiremysql://localhost/dbpostgres://Test it live
Live Regex TesterJS
0 matches/
/g
postgres://user:pass@localhost:5432/mydb postgresql://localhost/mydb postgresql://[email protected]:5432/app?sslmode=require
Use it in your language
Use it in
// JavaScript / Node.js
const regex = /^postgres(?:ql)?:\/\/(?:[^:@\/\s]+(?::[^@\/\s]*)?@)?[^:\/\s]+(?::\d+)?(?:\/[^\s?]+)?(?:\?\S*)?$/;
const value = "postgres://user:pass@localhost:5432/mydb";
const isMatch = regex.test(value);
console.log(isMatch); // true / false
// Extract all matches
const matches = value.match(/^postgres(?:ql)?:\/\/(?:[^:@\/\s]+(?::[^@\/\s]*)?@)?[^:\/\s]+(?::\d+)?(?:\/[^\s?]+)?(?:\?\S*)?$/g) || [];Tags
Frequently asked questions
How do I use the PostgreSQL Connection URI regex pattern in JavaScript?
Wrap the pattern in slashes: const re = /^postgres(?:ql)?:\/\/(?:[^:@\/\s]+(?::[^@\/\s]*)?@)?[^:\/\s]+(?::\d+)?(?:\/[^\s?]+)?(?:\?\S*)?$/; — then call re.test(value) to check a single value, or value.match(re) to find matches. The "Use it in" snippets above give you the exact code for 9 languages.
Is this postgresql connection uri regex production-ready?
Yes — every pattern in the library is tested against valid and invalid examples. Still, regex is one layer in a defense-in-depth strategy: pair it with server-side validation (e.g. Luhn for credit cards, mod-97 for IBAN, real DNS lookup for emails) for critical inputs.
Why does my pattern fail in another language?
Different regex engines (PCRE, Java, Python, Go's RE2) support slightly different syntax. The most common gotchas: lookbehinds (not in RE2), named groups syntax, and how backslashes need to be escaped inside string literals. The code snippets above already escape correctly for each language.
Can I edit this pattern and test it live?
Yes — use the live tester above. Type your test string and toggle flags (g, i, m, s, u, y) to see matches highlighted instantly, including capture groups.
Related patterns
See all Coding →Coding
Git Commit Hash
Validates Git commit SHA hash (short or full format)
CodingSemantic Version (SemVer)
Validates semantic versioning strings (MAJOR.MINOR.PATCH with optional pre-release and build metadata).
CodingHex Color Code
Validates CSS hex color codes in 3, 6, or 8-digit format (with optional alpha).
CodingJavaScript Identifier
Valid JS variable/function name.
Codingsnake_case Detection
Checks if a string is in snake_case format.
CodingGitHub Repository
Validates GitHub repository format (owner/repo).
Browse the full library — 250 tested regex patterns across 16 categories.