Re: CONCAT function equivalent - Mailing list pgsql-novice

Fabian Santiago wrote
> Ok,
>
> Here's another request, based on my first;
>
> instead of looking for a while to CONCAT my values into said table column,
> I tried this:
>
> UPDATE domain SET settings =
>
('default_language:en_US;default_user_quota:10240;default_groups:;min_passwd_length:0;max_passwd_length:0;disabled_domain_profiles:;disabled_user_profiles:;');
>
> this created 1 line in my column with all the listed values. How can
> create
> those same values in my column but in separate lines, one for each value?
> thanks for your help.
>
> - Fabian S.
>
> P.S. sorry about missing the reply all to the list; gmail only shows me
> the
> senders actual address, not the list address so i had to manually re-add
> the list address each time i reply i realized. thanks.
>
>
> On Sat, May 17, 2014 at 12:10 PM, Joe Conway <

> mail@

> > wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On 05/17/2014 08:43 AM, Fabian Santiago wrote:
>> > will your example literally take care of this task? i assume yours
>> > is only an example because you used 'foo' in there and I'm not sure
>> > where that comes into play. Excuse my naivety...I don't know
>> > postgresql too well (or at all) but need to use it for one server
>> > of mine. Thanks.
>>
>> You didn't post the definition of the table "domain" nor any sample
>> data, so the best I could do was a contrived example. When posting to
>> the lists it is best to post *complete* information in a form that can
>> be easily cut-and-pasted into a terminal to duplicate your problem.
>>
>> When you do this you make it easy for people to help you, therefore
>> you are more likely to get an answer, and the ones you do get will be
>> a more accurate reflection of your actual problem.
>>
>> Also, please keep replies on the list so others can learn from the
>> conversation later.
>>
>> Joe
>>
>> - --
>> Joe Conway
>> credativ LLC: http://www.credativ.us
>> Linux, PostgreSQL, and general Open Source
>> Training, Service, Consulting, & 24x7 Support
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.14 (GNU/Linux)
>> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>>
>> iQIcBAEBAgAGBQJTd4oEAAoJEDfy90M199hlIzwP/1RDogj62BypJyDuFp0oBlZZ
>> blic6vQlj8SBOz9b3cZ9DYqPE4Ue/sOaT5++hcJARLXBgT8MXq6I6VpcdWHindTs
>> j35be12MSukWO0ClDtwaYMG8syVph56LyPHdsz9QDql3T6GpNVz0vWreP7t9Y1oj
>> /psdYPSFyLfuvqGONhYVqNY8/K1866TF0crGuaYu43I5mdpHBxkZLhxZFw3pXX1O
>> ceShZaCz4x85beRwcZRUqpw5dqPwq8omeskFypRzOOG76GJohPikdYK9TM84xAUw
>> j00SCNStJsp9+TljtCtPP6sSnt+v0X6Kc/yF1z/AP7muKXRVkt+21iY6joP++muf
>> 8Y2LdbdVSNDIBDu3sui68dooOA8InmPmqzwXBcyqK6QrMJ8RMogsAFQvIvlMTNhZ
>> Wzr3S2hLznSzPEjo6tYcXvtr45/wjMga/KtyleSpTSI8rACY9bI42F6XtBk4lC9v
>> iJwfyhNuB0h0jdvSqdbmB/7f1On5zfMbRSp+hUtSAW727nwNZUX2uN6BYdCiDOh7
>> vzsycr2GYHc3SaK/teCI/MEjw11LjRxpMYDZPG/AtWuPL4egsUOZ9BlRHWuj4/if
>> LkmUZKbEl3VLNzrGWqjAdAGJrfDmQQaTGiCdMKdfiAVlPITE+uYvZ89coJ2G4sMK
>> AEtKoqMayFqychfNPc9z
>> =CTkC
>> -----END PGP SIGNATURE-----
>>
>
>
>
> --
> Sincerely,
>
> Fabian S.
> 862-432-2373

Sometimes the answers you get will be generic and you will need to adapt
them to your specific situation.  Like this one:

E'value1\nvalue2'

The E'' denotes that the supplied literal has escapes that need interpeting.
The "\n" is the escape for a newline.

David J.






--
View this message in context: http://postgresql.1045698.n5.nabble.com/CONCAT-function-equivalent-tp5804328p5804343.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.