network profile
| bio | website | linkedin.com/in/robbednark |
|---|---|---|
| location | Portland, Oregon, USA | |
| age | 44 | |
| visits | member for | 1 year, 3 months |
| seen | Sep 6 '12 at 19:15 | |
| stats | profile views | 4 |
Software Developer, most enthusiastically in Python and Django.
- http://www.facebook.com/rob.bednark
- http://www.linkedin.com/in/robbednark
- http://www.twitter.com/rbednark
- https://plus.google.com/u/0/114191719007713058554
- http://portlandupside.com
|
May 8 |
awarded | Popular Question |
|
Sep 6 |
comment |
How to list all views in SQL in PostgreSQL? Thanks @Phil. However, that command returns 128 rows, whereas \dv returns 57 rows. It seems to be giving me system views as well, like "tables", "columns", "domains", "pg_role", etc. How do I get just the views that I created? |
|
Sep 6 |
asked | How to list all views in SQL in PostgreSQL? |
|
Jul 27 |
revised |
How to verify postgresql db restore from pg_dump file Added sequence link that @ocharles gave in his comment. |
|
Jul 27 |
suggested | suggested edit on How to verify postgresql db restore from pg_dump file |
|
Jul 25 |
comment |
Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists? Thanks @Erwin_Brandstetter! Another excellent answer from you, I sure appreciate it. |
|
Jul 25 |
accepted | Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists? |
|
Jul 25 |
comment |
How to rename a Postgresql cluster? Thanks @Erwin_Brandstetter! Nice detailed answer with useful link to Martin Pitt's architecture. I will give your answer a try. |
|
Jul 25 |
accepted | How to rename a Postgresql cluster? |
|
Jul 24 |
comment |
How to rename a Postgresql cluster? @a_horse_with_no_name, I added pg_lsclusters output above. I'm new to this, but I believe you can have multiple clusters, and you have to identify which cluster you are talking to by its name (or maybe directory name, I'm not sure). |
|
Jul 24 |
revised |
Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists? Added update about what I found using pg_dropcluster |
|
Jul 24 |
revised |
How to rename a Postgresql cluster? Added pg_lsclusters output, and also added spacing to make more readable. |
|
Jul 24 |
revised |
Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists? Added a possible solution that I just found. |
|
Jul 24 |
asked | Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists? |
|
Jul 24 |
asked | How to rename a Postgresql cluster? |
|
Jul 18 |
awarded | Supporter |
|
Jul 18 |
comment |
How to verify postgresql db restore from pg_dump file Thanks @ocharles! "you need to check sequences too" -- what are "sequences"? |
|
Jul 18 |
accepted | How to verify postgresql db restore from pg_dump file |
|
Jul 18 |
revised |
postgresql: how do I dump and restore roles for a cluster? Added @dezso 's comment to the answer, as it ties in nicely, and will make it easier for future readers. |
|
Jul 18 |
suggested | suggested edit on postgresql: how do I dump and restore roles for a cluster? |
