PK/FK impacts using text data type

From: "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: PK/FK impacts using text data type
Date: 2015-01-09 16:22:40
Message-ID: 2BC18916DE4BF141AC1EFC55CE2CAE7D614327@NAEANRFKXM01V.nadsusea.nads.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 use in 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rob Cowell 2015-01-09 17:17:50 Replicating from 9.1.10 into 9.3.5
Previous Message Alvaro Herrera 2015-01-08 18:03:52 Re: PostgreSQL Dump rate is too slow