Datatype for a URL in PostgreSQL

Question

I need to store a URL in a PostgreSQL table. What is the best datatype for a field that will hold a URL with an undetermined length?

Thanks in advance.

Fabian Pijcke · Accepted Answer · 2017-01-13 11:46:35Z

49

The answer depends on what you intend to do with the data.

If you just need to store some uris in order to print them when requested, the text datatype seems indicated. There seems to be no standard about the maximum length of an url (note that browsers have their own limits, for example at least some years ago IE was limited to 2083 characters, but this is unrelated to our problem).

If you need some advanced operations on uris (for example, computing the base uri or extract some other parts), then you may want to use some libraries designed for this purpose. One example of such library (actually I know of no alternative) is pguri.

answered Jan 13, 2017 at 11:46

Fabian Pijcke

3,30027 silver badges30 bronze badges

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

2 Comments

pozs Over a year ago

Nice library you got there, I wasn't aware of that. The built-in FTS has some URI parsing facilities, but it's quite cumbersome to use it directly. -- i.e. select * from ts_debug('http://example.com:8080/foo/bar?baz=1')

Yigitalp Ertem May 16 at 17:15

I love reading these types of questions and answers, thanks

Collectives™ on Stack Overflow

Datatype for a URL in PostgreSQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related