Comments (5)
kristijanhusak
commented on May 16, 2024
1
This should be fixed now. Reopen if something is not working as expected.
from vim-dadbod-ui.
kristijanhusak
commented on May 16, 2024
1
It is schema. [table] . I'm not adding brackets to schema. I don't think people usually name the schema by reserved word.
from vim-dadbod-ui.
kristijanhusak
commented on May 16, 2024
Are square brackets in mssql same thing like quotes in postgres?
from vim-dadbod-ui.
eruizc-dev
commented on May 16, 2024
I've never used postgres. But in mssql you put square brackets around identifiers (database, tables, column names and others) to avoid conflicts with keywords.
Also when names have spaces in them
https://stackoverflow.com/questions/9917196/meaning-of-square-brackets-in-ms-sql-table-designer
from vim-dadbod-ui.
eruizc-dev
commented on May 16, 2024
@kristijanhusak it works! Thank you very much
But watching the commit I believe someone may run into trouble later since the syntax is as follows:
select top 200 * from [schema].[table]And from what I'm seeing it would generate the following:
select top 200 * from schema[table]Is this correct? Want me to open a new issue? Maybe submit a PR on it?
from vim-dadbod-ui.
Related Issues (20)
- Table Structure not showing properly. HOT 2
- Store query time per dbout buffer
- Ability to remove, reorder (or sort) preset table helpers
- Move the DBUI section to right HOT 1
- Possible to Add Option for Nvim-Notify to Track Query Time? HOT 4
- Keep the query output open while updating the query HOT 1
- Open query results in a window instead of a buffer
- Feature Request: Enhance Foreign Key Lookup to Consider Current Database Context in `schemas.vim`
- Cursorline and default mappings HOT 2
- DBUI stop working when given a wrong connection HOT 1
- Support for a new database HOT 3
- Table format off when text field includes line breaks HOT 1
- FR: Put views into a separate category
- Are there any options for "edit current entry" when browsing the result of a query?
- Duplicate tag "ic"
- Move Buffer output dropdown to respective database
- Show connection string of database HOT 1
- Oracle database not opening up properly HOT 3
- bind parameter delimiter config HOT 2
- Change `search_path` for session duration?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vim-dadbod-ui.