sergio dominguez dgsergi...@gmail.com writes:
I started to work with postgresql but i find that all the relations I create
disappear when I quit (\q) from the interactive terminal or after load a sql
file.
It's difficult to say for sure when you haven't showed us exactly what
you did, but one possibility is that you created the relations inside
a transaction and then forgot to commit the transaction before quitting.
Or perhaps you're creating them in a different database or different
schema than where you're subsequently looking. Note that \d without
any parameter will only show relations that are in your current
search_path.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs