-1

I am looking for similar commands in Postgres as in Git. The reason is that my debugging is slow in Postges, due to my inability to clone and do things like in Git.

  1. How can I clone a db, like a branch?
  2. How can I create a new "branch"?
  3. Is there some Git mode for Postgres?
  4. How do you deal with errors in Postgres?
    • Do you clone the db, or remove it and create new or something else?
flag
86% accept rate
1  
I don't get it - one is DBMS and the other is VCS. That's like asking if there's a MS Word mode in MS Visual Studio - they have something in common - working with text (and working with data in the case of git and Postgres) but not that much. – Milen A. Radev Aug 31 '09 at 9:01
Question doesn't make any sense. Same type of question: How can I use my table in the way I use my car? – depesz Aug 31 '09 at 10:19

1 Answer

2

  1. CREATE DATABASE newdb TEMPLATE olddb.

  2. You can't, if you mean you want copy-on-write. If not, see question 1.

  3. No. How would you expect that to work?

  4. What type of errors? Generally, you have your application respond to errors. If your application is in the database, in the form of stored procedures, you use the builtin exception handling in the language,

link|flag

Your Answer

get an OpenID
or
never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.