Temporary Advertisements:
Ad
Ad
Ad
SQL concate all available columns as one string
by proton_tb - Monday August 28, 2023 at 12:44 AM
#1
Is there any simple SQL select query to concate all available columns as one string without defining columns name?

It's like SELECT CONCATE(*) FROM table
Reply
#2
If you're on postgres you can try:

select rtrim(ltrim(replace(tablename::text, ',', ''), '('), ')') from tablename;
Reply
#3
(Aug 28, 2023, 07:18 AM)donarfio Wrote: If you're on postgres you can try:

select rtrim(ltrim(replace(tablename::text, ',', ''), '('), ')') from tablename;

Thank you. I'll try it..
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  DarkGPT Tutorial Easy idontknowmyname 201 14,688 2 hours ago
Last Post: yakuzah
  FREE WORMGPT TELEGRAM BOT olega1012 20 6,032 2 hours ago
Last Post: yakuzah
  OpenCode.ai best for vibe code czx 5 3,144 Yesterday, 03:36 PM
Last Post: nolookshot
  whats ur fav programming language chess 2 5,275 Yesterday, 03:35 PM
Last Post: nolookshot
  Top 10 Phishing Tools To Use 2024 Frontman 586 52,349 Oct 15, 2026, 06:31 PM
Last Post: matapts

Forum Jump:


 Users browsing this forum: 1 Guest(s)