Re: How do I save my tables? - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: How do I save my tables?
Date
Msg-id l19kd5$ers$2@ger.gmane.org
Whole thread Raw
In response to How do I save my tables?  (Kimberly Israel <kac15228@yahoo.com>)
Responses Re: How do I save my tables?  (David Johnston <polobo@yahoo.com>)
List 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.



pgsql-novice by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How do I save my tables?
Next
From: David Johnston
Date:
Subject: Re: How do I save my tables?