473,750 Members | 2,253 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 21201
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
2096
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
2394
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
2337
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
1071
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
4193
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
4332
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
22537
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
870
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
1735
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
8999
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8836
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
9256
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8260
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
6803
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
6080
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
4885
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3322
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
3
2223
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.