Postgres Pro
Downloads
Home   >   mailing lists

Re: print/return only the first X chars of a varchar column? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: print/return only the first X chars of a varchar column?
Date
Msg-id 200908310753.09061.aklaver@comcast.net
Whole thread Raw
In response to print/return only the first X chars of a varchar column?  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-general
Tree view 
On Monday 31 August 2009 7:49:12 am Kevin Kempter wrote:
> Hi all;
>
> I'm selecting from a table that has a varchar(1000) but I only want to
> display the firs 20 characters.  Looked at the string functions in the docs
> but nothing jumped out...
>
> Suggestions?
>
>
> Thanks in advance

substring(string [from int] [for int])


--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: print/return only the first X chars of a varchar column?
Next
From: Marc Munro
Date:
Subject: Looking for "proper" escape string syntax from pg_get_constraintdef