Regex that can extract a username and password from a postgresql connection string?

Question

How can I improve this regex (?<=\/\/)(.*?)(?=\@) to extract the username:password from a postgresql connection string.

I want to extract this string db-admin-username@server:this-is-funny-passowrd/is-continuing= from this string postgresql://db-admin-username@server:this-is-funny-passowrd/[email protected]/dbname

It returns the wrong string in case the password or username contains @

It should extract anything between // and the last @ characters.

Did you try substring('postgresql://db-admin-username@server:this-is-funny-passowrd/[email protected]/dbname' from '//(.*)@')? — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Dec 15, 2020 at 14:02
Thank you! @WiktorStribiżew, using this regex ` '//(.*)@'` returns the required string. — N. Solomon
– N. Solomon, Commented Dec 15, 2020 at 14:48

Wiktor Stribiżew · Accepted Answer · 2020-12-15 20:19:37Z

1

You can use

//(.*)@

In Python, you can use

re.findall(r'//(.*)@', text)

The .* will match from the leftmost // till the rightmost @, thus returning all the string you need.

edited Dec 15, 2020 at 20:19

answered Dec 15, 2020 at 14:50

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

N. Solomon Over a year ago

I wasn't particularly selecting from a database but the regex '//(.*)@' finds a match in a string.

Wiktor Stribiżew Over a year ago

@N.Solomon So, what should I keep in the answer? If it works for you as is please consider accepting the answer. Else, let me know what to fix.

N. Solomon Over a year ago

I only needed the regex //(.*)@ All I had to do in python is matches = re.findall(r'\/\/(.*)@',conn_string) or in Js ` connString.match(/\/\/(.*)@/g);`

Collectives™ on Stack Overflow

Regex that can extract a username and password from a postgresql connection string?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related