search

Borvik / vscode-postgres

PostgreSQL extension for vscode providing explorer, highlighting, diagnostics, and intellisense
MIT License
230 stars 48 forks source link

Can we expect support for Stored procedure. #50

Open amitdixit opened 6 years ago

amitdixit commented 6 years ago

As we expect support for stored proc and functions as currently we cannot find any of those.

Borvik commented 6 years ago

Well, as far as I know stored procs aren't available in postgres yet, except maybe in beta.

Functions are kinda supported, as they should be showing up in intellisense, though I think you mean in the DB explorer. I can see attempting to add the stored procedures to the intellisense when it becomes available.

My idea for the DB explorer was originally to be minimal, so it started with Server, DB, and Tables/Views. I was aware of schemas, but hadn't used them - and when they were pointed out, I could see the necessity including them there as well.

I was attempting to keep the DB tree fairly minimal, as this wasn't really a full management system (and I still don't plan to craft a gui to create/manage table structures. Adding this to the explorer would mean adding another level under the schema. I'm not opposed to it, but I'm not sure I'm ready yet - depends on the demand for it.

lnicola commented 6 years ago

:+1: for displaying the functions in the DB explorer.