SQLite Forum

pragma_.. fails
Login

pragma_.. fails

(1) By acromarco on 2021-06-03 12:33:47 [link]

This works:
```
pragma table_info(my_table)
--> (returns my_table with info for each row)
```

But this doesn't:
```
SELECT * FROM pragma_table_info(my_table) 
returns --> near "(": syntax error
```
i tried with and without quotes around my table name, no effect.
what am i missing or misunderstanding?  
I am using:
```
select sqlite_version() 
--> 3.7.13
```

(2) By anonymous on 2021-06-03 12:49:24 in reply to 1 [link]

Pragma functions were added in 3.16.
On a related note, 3.7.13 will hit 9 years old in just 8 days. You should update if at all possible to get nearly a decade of bug fixes and features.

(4) By acromarco on 2021-06-03 19:20:43 in reply to 2

thanks, wow indeed that's an antique version, unfortunately that's all we got in this Coursera class project, so i can't do much else than forwarding your just advice.

(3) By Richard Hipp (drh) on 2021-06-03 12:52:32 in reply to 1 [link]

That feature was added in 3.16.0 (2017-01-02).  Version 3.7.13 dates from 2012-06-11.

(5) By acromarco on 2021-06-03 19:31:43 in reply to 3 [link]

i should have suspected, thanks!  unfortunately i don't have control over the version used in this Coursera class