Database Reference
In-Depth Information
Product numbering - isn
Data types are used to store product data following the international standard and serial
numbers such as ISSN (serial), UPC, ISBN (books), EAN13, ISMN (music). The numbers
are validated.
In this example, you will create a table of topics, with the data type ISBN for the
id
field,
and you will insert a topic:
$ heroku pg:psql --app your-app-name
CREATE EXTENSION isn;
CREATE TABLE books (id isbn, name text);
INSERT INTO books (id, name) VALUES ('9780307465351', 'The
4-Hour Workweek');
This extension is very simple and you can find all data types supported in the documenta-
