public inbox for [email protected]
help / color / mirror / Atom feedFrom: Igor Korot <[email protected]>
To: David G. Johnston <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: How to get the data from the query
Date: Sun, 27 Apr 2025 00:44:34 -0500
Message-ID: <CA+FnnTz8f5bWZpX=6rtdoAmJy0i_yx3Nk9p0a93nfUwW1SC3aA@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwa+vG9uA2cwF9csnXkUqeoCBxCV0Huz=_MOyRuVXyk+aw@mail.gmail.com>
References: <CA+FnnTxPsPRzOtLGh7389gwjS3tOJaLpQ3Jhxi26UOr9BW5a+g@mail.gmail.com>
<CAKFQuwa+vG9uA2cwF9csnXkUqeoCBxCV0Huz=_MOyRuVXyk+aw@mail.gmail.com>
Hi, David,
On Sat, Apr 26, 2025 at 8:06 PM David G. Johnston
<[email protected]> wrote:
>
> On Saturday, April 26, 2025, Igor Korot <[email protected]> wrote:
>>
>> but the size comes out "" (empty)
>>
>
> What is the value you are expecting?
Expecting to have "100".
What is the minimal table definition (i.e., a one or few column
table) that would produce this expected value?
CREATE TABLE IF NOT EXISTS leagues(id integer primary key, name
varchar(100), drafttype integer, scoringtype integer, roundvalues
integer, leaguetype char(5), salary integer, benchplayers integer);
Field "name" should be 100.
What does psql show if you use it to output the query against that table?
draft=# SELECT column_name, data_type, character_maximum_length,
numeric_precision, table_name FROM information_schema.columns WHERE
column_name = 'name' ORDER BY tabl
e_name;
column_name | data_type | character_maximum_length |
numeric_precision | table_name
-------------+-------------------+--------------------------+-------------------+---------------------------------
name | text | |
| abcß
name | character varying | 100 |
| leagues
name | name | |
| pg_available_extension_versions
name | name | |
| pg_available_extensions
name | text | |
| pg_config
name | text | |
| pg_cursors
name | text | |
| pg_file_settings
name | text | |
| pg_prepared_statements
name | text | |
| pg_settings
name | text | |
| pg_shmem_allocations
name | text | |
| pg_stat_slru
name | text | |
| pg_timezone_names
name | character varying | 70 |
| players
name | character varying | 50 |
| teams
(14 rows)
draft=#
Query is shorter, but it gives the result of 100.
Let me try the full one from my code...
Thank you.
>
> David J.
>
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How to get the data from the query
In-Reply-To: <CA+FnnTz8f5bWZpX=6rtdoAmJy0i_yx3Nk9p0a93nfUwW1SC3aA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox