Postgres Pro
Downloads
Home   >   mailing lists

PK/FK impacts using text data type - Mailing list pgsql-admin

From Ferrell, Denise CTR NSWCDD, Z11
Subject PK/FK impacts using text data type
Date
Msg-id 2BC18916DE4BF141AC1EFC55CE2CAE7D614327@NAEANRFKXM01V.nadsusea.nads.navy.mil
Whole thread Raw
Responses Re: PK/FK impacts using text data type  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view 
Good Morning,

Using Linux/PostgreSQL 9.3.

We have been discussing whether or not to change all of our varchar (character varying) data types to text for ease of
usein procedures/functions/triggers... 

Are there any impacts on keys by using text data type vs. character varying or character varying(n)?

Thank you in advance,
Denise Ferrell

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL Dump rate is too slow
Next
From: Rob Cowell
Date:
Subject: Replicating from 9.1.10 into 9.3.5