CODEWITHSUNDEEP
sqlpostgresqlpgadmin
kp singh
kp singh

Reputation: 175

Can we create tables in PGADMIN4 without specifying the datatype's length?

I am new to PostgresSQL and using pgadmin4 on my Windows machine, While creating tables came across datatypes like- char and char[] and also char Varying and char Varying[].

I want to know is there a method by which I can create an attribute name specifying the datatype but not length?

Upvotes: 0

Views: 55

Answers (2)

kps
kps

Reputation: 60

the datatype like char or varchar will do the work you want to do

Upvotes: 1

Laurenz Albe
Laurenz Albe

Reputation: 246403

Yes: use the text data type. It performs just as well and has no length limit (there is an absolute size limit of 1GB though).

Upvotes: 0

Related Questions