MIME-Version: 1.0
References: <CA+FnnTxPsPRzOtLGh7389gwjS3tOJaLpQ3Jhxi26UOr9BW5a+g@mail.gmail.com>
 <CAKFQuwa+vG9uA2cwF9csnXkUqeoCBxCV0Huz=_MOyRuVXyk+aw@mail.gmail.com>
In-Reply-To: <CAKFQuwa+vG9uA2cwF9csnXkUqeoCBxCV0Huz=_MOyRuVXyk+aw@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sun, 27 Apr 2025 00:53:12 -0500
Message-ID: <CA+FnnTx7X1sREPD1c5c3Svky7-urRp-axFhYB1Dxgm3xscxj1w@mail.gmail.com>
Subject: Re: How to get the data from the query
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTx7X1sREPD1c5c3Svky7-urRp-axFhYB1Dxgm3xscxj1w%40mail.gmail.com>
Precedence: bulk

Now this query still works:

[code]
draft=3D# SELECT DISTINCT column_name, data_type,
character_maximum_length, character_octet_length, numeric_precision,
numeric_precision_radix, numeric_scale, is_nullabl
e, column_default, ordinal_position FROM information_schema.columns
WHERE table_name=3D'leagues' ORDER BY ordinal_position;


column_name  |     data_type     | character_maximum_length |
character_octet_length | numeric_precision | numeric_precision_radix |
numeric_scale | is_nullable | col
umn_default | ordinal_position
--------------+-------------------+--------------------------+-------------=
-----------+-------------------+-------------------------+---------------+-=
------------+----
------------+------------------
id           | integer           |                          |
              |                32 |                       2 |
   0 | NO          |
           |                1
name         | character varying |                      100 |
          400 |                   |                         |
     | YES         |
           |                2
drafttype    | integer           |                          |
              |                32 |                       2 |
   0 | YES         |
           |                3
scoringtype  | integer           |                          |
              |                32 |                       2 |
   0 | YES         |
           |                4
roundvalues  | integer           |                          |
              |                32 |                       2 |
   0 | YES         |
           |                5
leaguetype   | character         |                        5 |
           20 |                   |                         |
     | YES         |
           |                6
salary       | integer           |                          |
              |                32 |                       2 |
   0 | YES         |
           |                7
benchplayers | integer           |                          |
              |                32 |                       2 |
   0 | YES         |
           |                8
(8 rows)

[/code]

Thank you.

On Sat, Apr 26, 2025 at 8:06=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Saturday, April 26, 2025, Igor Korot <ikorot01@gmail.com> wrote:
>>
>> but the size comes out "" (empty)
>>
>
> What is the value you are expecting?  What is the minimal table definitio=
n (i.e., a one or few column table) that would produce this expected value?=
  What does psql show if you use it to output the query against that table?
>
> David J.
>