Timeline for Is there a Postgres admin GUI that can execute a master file containing multiple sql files
Current License: CC BY-SA 3.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 18, 2017 at 21:16 | vote | accept | jnmitch | ||
| Mar 17, 2017 at 21:04 | answer | added | Evan Carroll | timeline score: 2 | |
| Mar 17, 2017 at 20:14 | comment | added | Evan Carroll | @jbits what operating system are you using? | |
| Mar 11, 2017 at 18:33 | comment | added | McNets | Community Guide to PostgreSQL GUI Tools | |
| Nov 8, 2016 at 7:31 | comment | added | FlogFR | What you want is a "plan", sqitch or bash script can do that. I don't know any GUI that do that though. | |
| Mar 31, 2015 at 4:39 | history | tweeted | twitter.com/#!/StackDBAs/status/582764016465895424 | ||
| Mar 14, 2013 at 7:23 | comment | added | jnmitch | Thanks @a_horse_with_no_name. I noticed in the URL referenced that: "If the included SQL script contains SELECT queries, the result of those queries will not be displayed in the GUI". My scripts have many select statements. To confirm this disclaimer, I tested this product using the WbInclude command on a very simple script containing a select and confirmed it doesn't display the results. I wonder why? Anyway, aside from that, this product definitely works at calling other scripts within scripts. | |
| Mar 13, 2013 at 22:59 | comment | added | user1822 | SQL Workbench/J can do that: sql-workbench.net/manual/wb-commands.html#command-wbinclude | |
| Mar 13, 2013 at 18:43 | history | edited | jnmitch | CC BY-SA 3.0 |
opened up question to any postrgres product, not just pgAdmin
|
| Mar 13, 2013 at 18:34 | comment | added | jnmitch | Thanks for the comment. And you'll be able to see that it is a problem without a solution if you attempt to do what I want in pgAdmin. It may be a limitation (WADU) of pgAdmin, as you say, so I'll edit my question to open it up to asking for ANY postgres GUI that will do this. | |
| Mar 13, 2013 at 8:41 | comment | added | András Váczi | OK, then I will be clear: you presumably can't do that in pgAdmin. Anyway, I can't really see why this is a problem (I may be too used to this limitation). | |
| Mar 13, 2013 at 3:59 | history | edited | jnmitch | CC BY-SA 3.0 |
added 64 characters in body
|
| Mar 13, 2013 at 0:30 | history | edited | jnmitch | CC BY-SA 3.0 |
added 56 characters in body
|
| Mar 12, 2013 at 23:43 | history | edited | jnmitch | CC BY-SA 3.0 |
added 142 characters in body
|
| S Mar 12, 2013 at 20:58 | history | suggested | Stephane Rolland | CC BY-SA 3.0 |
remove Thanks!
|
| Mar 12, 2013 at 20:28 | review | Suggested edits | |||
| S Mar 12, 2013 at 20:58 | |||||
| Mar 12, 2013 at 20:15 | comment | added | András Váczi |
You can edit your SQL files in any editor (there are much better options than pgAdmin) and then only run a single command in psql (say psql -f master.sql).
|
|
| Mar 12, 2013 at 19:32 | review | First posts | |||
| Mar 12, 2013 at 19:49 | |||||
| Mar 12, 2013 at 19:13 | history | asked | jnmitch | CC BY-SA 3.0 |