|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
April 26th, 2008, 10:11 PM
|
|||
|
|||
|
Deleting imported databases
hey guys, i use:
\i filename.sql to import my databases into postgre, what i want to know is how to remove them from memory. Each time i load psql it keeps all the tables i have imported and when i want to import a new lot of data that has tables with similar names it clashes with the existing data. is there some sort of command to remove them or refresh the memory? Cheers.
|
|
#2
April 27th, 2008, 04:11 AM
|
||||
|
||||
|
Check the manual for DROP
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Deleting imported databases |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
