PostGreSQL Create Function from VBA

Question

I have set up an ADO connection to a PostgreSQL database. I was wondering if it were possible from VBA to create functions - e.g I have a DatabaseSetUp function, creating tables and whatnot. I was hoping that I could then add in some functions from VBA.

Possible? If so, could I trouble someone for an example

Thanks

It's hard to understand exactly what you mean here. Are you trying to create stored procedures/in-database functions written in VBA? Use VBA to create PL/PgSQL stored procs/functions? What? — Craig Ringer
– Craig Ringer, Commented May 15, 2013 at 0:11
Sorry was a late night question. I want to create pgSQL funtions from vba and store them in a newly deployed database. A setup/install sub in vba that creates the db, creates tables, then creates funtions that I want to have in the db — Mr.Adam
– Mr.Adam, Commented May 15, 2013 at 5:26
statement for function creating is usual SQL statement like other SQL statements. Just send to database SQL command like "CREATE OR REPLACE FUNCTION ...". There are no some special access necessary. — Pavel Stehule
– Pavel Stehule, Commented May 15, 2013 at 8:12

Craig Ringer · Accepted Answer · 2013-05-15 08:35:53Z

1

It's the same as any other SQL like ordinary SELECTs. Just send the SQL.

You might want to query pg_proc, pg_class, etc (or the information_schema) to determine what already exists, though most statements have IF EXISTS or CREATE OR REPLACE variants.

answered May 15, 2013 at 8:35

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostGreSQL Create Function from VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related