Re: CONCAT function equivalent - Mailing list pgsql-novice
| From | Fabian Santiago |
|---|---|
| Subject | Re: CONCAT function equivalent |
| Date | |
| Msg-id | CAP4E921efQMVbtN-ef7bbK+6YkGuuSMFRPWWT6xHbhGhvCtUGw@mail.gmail.com Whole thread Raw |
| In response to | CONCAT function equivalent (Fabian Santiago <fabian.santiago@gmail.com>) |
| Responses |
Re: CONCAT function equivalent
(David G Johnston <david.g.johnston@gmail.com>)
|
| List | pgsql-novice |
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@joeconway.com> 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
pgsql-novice by date: