Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support DESCRIBE statement #1113

Open
LeoDog896 opened this issue Mar 2, 2023 · 4 comments · May be fixed by #1169
Open

Support DESCRIBE statement #1113

LeoDog896 opened this issue Mar 2, 2023 · 4 comments · May be fixed by #1169
Labels
enhancement New feature or request

Comments

@LeoDog896
Copy link
Contributor

https://jakewheat.github.io/sql-overview/sql-2016-foundation-grammar.html#_20_10_describe_statement

The describe statement is particularly useful for finding out information about a table without digging in deep.
@devgony
Copy link
Collaborator

devgony commented Mar 3, 2023

Currently, you can use .columns TABLE_NAME command

gluesql> CREATE TABLE User (id INT, name TEXT);
Table created

gluesql> .columns User;
Field Type
id INT
name TEXT

@LeoDog896
Copy link
Contributor Author

Interesting - is this the standard way to do it or is it a custom command by gluesql?

@devgony
Copy link
Collaborator

devgony commented Mar 3, 2023

.columns is gluesql's custom command but cli mode only, not SQL
So, it would be nice if you contribute to implement DESCRIBE SQL Statement

@panarch panarch added the enhancement New feature or request label Mar 3, 2023
@pythonbrad pythonbrad linked a pull request May 2, 2023 that will close this issue
Open
@pythonbrad
Copy link
Contributor

@devgony , i done a pull request for it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add DESCRIBE statement pythonbrad/gluesql
4 participants
@panarch @LeoDog896 @pythonbrad @devgony