Can we create a column of character varying(MAX) with PostgreSQL database

postgresql postgresql-9.3 sqldatatypes
Samir picture Samir · Mar 29, 2016 · Viewed 25.3k times · Source

I am unable to set the max size of particular column in PostgreSQL with MAX keyword. Is there any keyword like MAX. If not how can we create the column with the maximum size?

Answer

a_horse_with_no_name picture a_horse_with_no_name · Mar 29, 2016

If you want to created an "unbounded" varchar column just use varchar without a length restriction.

From the manual:

If character varying is used without length specifier, the type accepts strings of any size

So you can use:

create table foo
( 
  unlimited  varchar
);

Another alternative is to use text:

create table foo
( 
  unlimited text
);

More details about character data types are in the manual:
http://www.postgresql.org/docs/current/static/datatype-character.html

Related questions

How do I modify fields inside the new PostgreSQL JSON datatype?

With postgresql 9.3 I can SELECT specific fields of a JSON data type, but how do you modify them using UPDATE? I can't find any examples of this in the postgresql documentation, or anywhere online. I have tried the obvious: postgres=# …

Read More
How do I query using fields inside the new PostgreSQL JSON datatype?

I am looking for some docs and/or examples for the new JSON functions in PostgreSQL 9.2. Specifically, given a series of JSON records: [ {name: "Toby", occupation: "Software Engineer"}, {name: "Zaphod", occupation: "Galactic President"} ] How would I write the SQL to …

Read More
postgresql sequence nextval in schema

I have a sequence on postgresql 9.3 inside a schema. I can do this: SELECT last_value, increment_by from foo."SQ_ID";` last_value | increment_by ------------+-------------- 1 | 1 (1 fila) But this doesn't work: SELECT nextval('foo.SQ_ID'); ERROR: no …

Read More