In Postgres 8.1.1, Win XP, I tried to create some temporary tables by using pgAdmin. For example, I executed :
CREATE TEMP TABLE privremena
(
)
INHERITS (plants)
WITHOUT OIDS
TABLESPACE pg_default;
ALTER TABLE privremena OWNER TO matalab;

Although query was successfully executed, I just can't find temporary table. I don't see it anywhere in the database, even when I refresh the database. Where is it?

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJan 16, '06 at 10:40a
activeJan 16, '06 at 10:40a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Zlatko Matić: 1 post

People

Translate

site design / logo © 2022 Grokbase