SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Milan, Italy
    Posts
    152
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Export PostgreSQL

    Hello

    I have a database written in postgresql in computer "A" I would like to have the same database and tables in computer "B"

    Is it possible to do an export ??

    Thank you.
    dReAm

  2. #2
    SitePoint Zealot
    Join Date
    Feb 2005
    Posts
    195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you probably want to use the pg_dump command
    Set up a free Instant Arcade!!
    Find the domainname you want at ExpireWorks.com
    Free $6.95 directi account

  3. #3
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    Milan, Italy
    Posts
    152
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ohh thanks.. I noted that there is no IF in postgresql...I have to use CASE ??

    It's this..When i create a table i want it to check if it is already created..If it is i want it to drop the table and Create it again..How can i do something like this ??
    dReAm

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    mysql has a DROP TABLE IF EXISTS command. check the pgsql manual and see if their syntax is similar.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •