473,700 Members | 2,838 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to import schema?

61 New Member
I want to import a schema from database to another,
how can I do that?

Thanks.
Mar 10 '11 #1
3 21197
rski
700 Recognized Expert Contributor
I think you can use pg_dump tool to do that.
Mar 11 '11 #2
Amin M Salih
2 New Member
you can use the following
psql dbname < infile
Jul 7 '11 #3
hikmat
4 New Member
you can use pg_dumpall > filename. Then to restore you can psql -f filename databasename
Sep 20 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2093
by: Hari Om | last post by:
Subject: XML Schema to XML Schema Conversion I have an XML Schema A which needs to mapped to another XML Schema B. Is there any handy tool which I could use to convert from Schema A to Schema B? Any related informaiton on this is appreciated. Thanks!
4
2391
by: Gordon Dickens | last post by:
I have target xml to generate from schema. All of the XML instances have the same global element i.e. <base>. I would like to combine all of the schemas into a single schema where I could generate any of the specific instances. sample schema one: <?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="base">
2
2335
by: lbolognini | last post by:
Hi all, I've got a PostgreSQL schema, how can I import it in SqlExpress? What's the best tool for administering Sql Express. Thanks, Lorenzo
0
1069
by: Mike Voissem | last post by:
Is there a way in vb.net to emulate\mimic the import wizard from access\excel\dts? I have a request to give a user a gui that will allow them to create an import schema for a text file, and if I can, I'd like to use one of those import wizards to allow them to do that. Thanx, Mike -- Mike Voissem Lead Software Engineer
2
4189
by: M Rao | last post by:
I have xml data coming in as a stream from a web service running against exchange server.The attributes for the elements dtstart and dtend, b:dt="dateTime.tz" xmlns:b="urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/, are causing trouble. I tried to create schema using xmlspy and I get an error saying name "b:dt" cannot have a namespace prefix. I am new to xml. Can somebody please help with schema. <appointments> <appointment>
1
4327
by: Stephen Edgecombe | last post by:
Hi Environment: Visual Studio .NET 2003 (vb) I am developing an XSD Schema and want to include some building blocks from another source, so they have a different namespace. - If I use an <Include> the Schema doesn't show any of the Elements from the include Schema. But that's to be expected because they are in a different namespace. - If I use <Import> the Schema doesn't show any of the Elements from the
2
22514
by: Carmit | last post by:
Hi, I'm trying to build a proxy for this webservice: http://webservices.sabre.com/wsdl/sabreXML1.0.00/tpf/EndTransactionLLSRQ.wsdl I'm getting the following error: Error: Unable to import binding 'EndTransactionSoapBinding' from namespace 'http s://webservices.sabre.com/websvc'.
0
868
by: Anbu.Thangarathinam | last post by:
Hi All, I'm looking for a help on stub generation form wsdl files using wsdl.exe supplied by visual studio 2005. My probelm is exactly similar to the query posted in http://groups.google.be/group/microsoft.public.dotnet.framework.webservices/browse_frm/thread/ab236c1cf7b458e2/5d10be4a5d6092d1 But, how to overcome this problem,
1
1730
by: Arndt Jonasson | last post by:
Let's say an XML Schema schema A uses types from another schema B. Then, if I understand things correctly, A needs to import schema B (maybe "importing its namespace" is more correctly put). It is also allowed for both A and B to import the XML Schema namespace, but at least when I use the xmllint validator, it isn't necessary. My question is, is it ever necessary to import the XML Schema namespace? If not necessary, when might it be...
0
8638
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9202
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9058
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7791
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6555
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5894
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4649
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3081
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2371
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.