Re: How do I save my tables?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do I save my tables?
Date: 2013-09-17 13:12:52
Message-ID: l19kd5$ers$2@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Kimberly Israel, 17.09.2013 14:33:
> Yesterday I created several tables and was able to run queries that
> combined data from more than one table at a time, but when I reopened
> pgAdmin III today, the database I had created was there, but the
> tables were all gone. I tried to save my work, but what got saved
> was a .sql file that seems to only contain the code for creating the
> database. Basically what I need to know is how do I put my tables
> somewhere where I'll be able to continue working with them after a
> period of having the computer off?

This all sounds like you forgot to commit your changes.

When you have auto-commit disabled you need to commit every change you make to the database - including a CREATE TABLE statement.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Johnston 2013-09-17 14:22:25 Re: How do I save my tables?
Previous Message Thomas Kellerer 2013-09-17 13:11:31 Re: How do I save my tables?