Unix Technical Forum

.sql howto

This is a discussion on .sql howto within the pgsql Novice forums, part of the PostgreSQL category; --> hi everyone, i have a database.sql file and i need to store/restore in my server. i've been searching for ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 09:19 PM
Ahmed Sarwar
 
Posts: n/a
Default .sql howto

hi everyone, i have a database.sql file and i need to
store/restore in my server. i've been searching for a
while but couldn't find anything understandable(by me).
it would be better if there's any easy to understand
hands-on-experi kind of tutorial. thanks in advance.

( will i ever be able to deal with SQL at all???)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 09:19 PM
Kretschmer Andreas
 
Posts: n/a
Default Re: .sql howto

am Fri, dem 07.01.2005, um 15:09:29 +0900 mailte Ahmed Sarwar folgendes:
> hi everyone, i have a database.sql file and i need to
> store/restore in my server. i've been searching for a
> while but couldn't find anything understandable(by me).


You can read the file with \i in psql or call psql with the -f -
Option. Please read the man-page.



> it would be better if there's any easy to understand
> hands-on-experi kind of tutorial. thanks in advance.


Please go to the web-page, there are any documentation.


Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:56 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com