Re: [SQL] How To Create Temporary Table inside a function

On Fri, Mar 2, 2012 at 3:49 AM, Philip Couling wrote: > Hi Rehan > > I suggest attempting to drop the table before you create the temp table: > DROP TABLE IF EXISTS table1; > > See: > http://www.postgresql.org/docs/current/static/sql-droptable.html > > > Also if you're using an actual TEMP table,

Re: [SQL] Change Ownership Recursively

iamunix=# \c postgres was really meant to be: iamunix=# \c - postgres The first changes to database postgres as current user, the second changes the user while remaining on the current database. This is very helpful! psql> \c - username_for_new_connection -- Emi -- Sent via pgsql-sql m

Re: [SQL] How to shrink database in postgresql

2012/2/29 Pavel Stehule : > Hello > > the most similar tool in pg is "VACUUM FULL" statemet; Hello, From: http://wiki.postgresql.org/wiki/VACUUM_FULL "Many people, either based on misguided advice on the 'net or on the assumption that it must be "better", periodically run VACUUM FULL on their tab

Re: [SQL] How To Create Temporary Table inside a function

Hi Rehan I suggest attempting to drop the table before you create the temp table: DROP TABLE IF EXISTS table1; See: http://www.postgresql.org/docs/current/static/sql-droptable.html Also if you're using an actual TEMP table, PostgreSQL can automatically drop the table or just empty it once the t

[SQL] How To Create Temporary Table inside a function

hi everyone , how can i create temp table say table1 with three column of types varchar , int and int, inside the function body and if that same table already exist it should drop that already existing table(table1) , and on every run this process should run. and how can i insert values from pos