Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

changing a db name

Status
Not open for further replies.
keak

keak

Programmer
Sep 12, 2005
247
CA
Hi there,
Does anyone know how I can change the db name (keeping all the existing tables/funcitons) via sql or pgadmin?

Ive been looking around but can't really find where i'd do this ....

THanks :)
 
Sort by date Sort by votes
Surprises me that you could not find it. Its very easy to find.

Here is the prototype...

ALTER DATABASE name RENAME TO newname

Try that.

Gary
gwinn7
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
149
feherke
feherke
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
144
dbuxton101
dbuxton101
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
137
wbower34
wbower34
OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
143
OJSan
OJSan
RobNorthcott
  • Locked
  • Question
How to get user name of record lock
Replies
1
Views
71
RobNorthcott
RobNorthcott

Part and Inventory Search

Sponsor

Back
Top