Questions tagged [format]

The tag has no usage guidance.

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
372 views

Does Postgres have a function for converting text into ASCII escaped or HTML escaped text?

Is there a builtin Postgres function that converts multi-line text into ASCII escaped or HTML escaped form and vice versa? I need to store multi-line text as name=value pairs, basically line .ini ...
1
vote
3answers
2k views

How to select different format of the date in mysql

I have this table and I can't change its format to yyyy-mm-dd because I have so many scripts that are related to this format dd-mm-yyyy. It would be a mess if I change its format. Id date ...
0
votes
0answers
16 views

Change Table format from within MySQL 8?

Is there a mysql command to change the output format of a table? Specifically, I'd like to get rid of the formatting '-'s and '+'s: +------+------------+ | ID | Name | +------+------------+ | ...
0
votes
0answers
15 views

How to set the view format of pgAdmin4's query results?

I'm learning to use pgAdmin4 in my work, but the query results are hard to be read since every columns are too long. For example, there is a column in a query result, whose type is double. In fact I ...
0
votes
0answers
34 views

Retrieve and format TEXT column into .csv file

I'm performing a SQL query that simply pulls data from a database into a .csv file. Using a SELECT * statement and specifying the columns to pull all came over fine except any free standing TEXT ...
0
votes
0answers
33 views

loading k:v pairs from DB into JS Object

I'm creating a single player web RPG. I'm debating the following method of storing/retrieving quest items per player id: In userstats table, have a quest_items column of type mediumtext, where I ...