Skip to content

Instantly share code, notes, and snippets.

@andrewpetrochenkov

andrewpetrochenkov/postgres-basename.sql

Last active August 3, 2024 14:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save andrewpetrochenkov/ecbb87a71c2875af7036a12731a9aa7a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save andrewpetrochenkov/ecbb87a71c2875af7036a12731a9aa7a to your computer and use it in GitHub Desktop.
Download ZIP
postgres basename(path) function
Raw
postgres-basename.sql
CREATE OR REPLACE FUNCTION basename(path text) RETURNS text AS $$
SELECT reverse((regexp_split_to_array(reverse($1), '/'))[1])
$$
LANGUAGE SQL IMMUTABLE;
SELECT basename('/Users/username/git/owner/repo');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment