Now this query still works:
[code]
draft=# 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='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 PM 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 definition (i.e., a one or few column table) that
wouldproduce this expected value? What does psql show if you use it to output the query against that table?
>
> David J.
>
