pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres import
3+ messages / 3 participants
[nested] [flat]

* postgres import
@ 2006-10-31 08:30  Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Antonios Katsikadamos @ 2006-10-31 08:30 UTC (permalink / raw)
  To: pgsql-admin

Hi all,
   
   
  sorry again for the trouble. I have a small problem in postgres, I have a .sql file (  db dump  ) and i want to import it in postgres on linux. 
   
   
  does anyone know how to do it?
   
  Thnx a lot for your time

 		
---------------------------------
Get your email and more, right on the  new Yahoo.com 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgres import
@ 2006-10-31 08:35  Achilleas Mantzios <achill@matrix.gatewaynet.com>
  parent: Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Achilleas Mantzios @ 2006-10-31 08:35 UTC (permalink / raw)
  To: pgsql-admin

Óôéò Ôñßôç 31 Ïêôþâñéïò 2006 10:30, ï/ç Antonios Katsikadamos Ýãñáøå:
> Hi all,
>
>
>   sorry again for the trouble. I have a small problem in postgres, I have a
> .sql file (  db dump  ) and i want to import it in postgres on linux.
>

% psql
\i <file>.sql

>
>   does anyone know how to do it?
>
>   Thnx a lot for your time
>
>
> ---------------------------------
> Get your email and more, right on the  new Yahoo.com

-- 
Achilleas Mantzios



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgres import
@ 2006-10-31 10:49  Adam Radlowski <adamr@informatyka.gdansk.pl>
  parent: Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Adam Radlowski @ 2006-10-31 10:49 UTC (permalink / raw)
  To: Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>; +Cc: pgsql-admin

Achilleas informed You very good. But if Your SQL file comes from other 
DBMS, like MySQL, You have to a little bit to edit this file, becouse 
sometimes in those files are used "slangs" characteristical for specific 
DBMS.
If You have SQL file genarated with "pg_dump", You have to be sure, that 
all needed roles (users, groups) are defined in Your destination 
database, when in SQL file You have GRANT or REVOKE.
Greetings
Adam

Antonios Katsikadamos wrote:

> Hi all,
>  
>  
> sorry again for the trouble. I have a small problem in postgres, I 
> have a .sql file (  db dump  ) and i want to import it in postgres on 
> linux.
>  
>  
> does anyone know how to do it?
>  
> Thnx a lot for your time
>
> Get your email and more, right on the new Yahoo.com 
> <http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview;





^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-10-31 10:49 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-31 08:30 postgres import Antonios Katsikadamos <antonioskatsikadamos@yahoo.com>
2006-10-31 08:35 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2006-10-31 10:49 ` Adam Radlowski <adamr@informatyka.gdansk.pl>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox