<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[Форум PHP-MyAdmin.RU &mdash; Mysql и  PostgreSQL]]></title>
		<link>https://forum.php-myadmin.ru/viewtopic.php?id=1650</link>
		<atom:link href="https://forum.php-myadmin.ru/extern.php?action=feed&amp;tid=1650&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[Недавние сообщения в теме «Mysql и  PostgreSQL».]]></description>
		<lastBuildDate>Thu, 01 Apr 2010 15:02:14 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Mysql и  PostgreSQL]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=11461#p11461</link>
			<description><![CDATA[<p><strong>anonim2008</strong><br />К сожалению не знаю как конвертировать таблицы из Postgres в MySQL.</p>]]></description>
			<author><![CDATA[null@example.com (Hanut)]]></author>
			<pubDate>Thu, 01 Apr 2010 15:02:14 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=11461#p11461</guid>
		</item>
		<item>
			<title><![CDATA[Mysql и  PostgreSQL]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=11458#p11458</link>
			<description><![CDATA[<p>Есть БД сделаная в&nbsp; PostgreSQL около 15 мб(200 тыс строк) , </p><p>[spoiler]</p><br /><p>-- PostgreSQL database dump<br />--</p><p>SET client_encoding = &#039;KOI8&#039;;<br />SET standard_conforming_strings = off;<br />SET check_function_bodies = false;<br />SET client_min_messages = warning;<br />SET escape_string_warning = off;</p><p>--<br />-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pgsql<br />--</p><p>COMMENT ON SCHEMA public IS &#039;Standard public schema&#039;;</p><br /><p>SET search_path = public, pg_catalog;</p><p>--<br />-- Name: gtsq; Type: SHELL TYPE; Schema: public; Owner: nehpus<br />--</p><p>CREATE TYPE gtsq;</p><br /><p>--<br />-- Name: gtsq_in(cstring); Type: FUNCTION; Schema: public; Owner: nehpus<br />--</p><p>CREATE FUNCTION gtsq_in(cstring) RETURNS gtsq<br />&nbsp; &nbsp; AS &#039;$libdir/tsearch2&#039;, &#039;gtsq_in&#039;<br />&nbsp; &nbsp; LANGUAGE c STRICT;</p><br /><p>ALTER FUNCTION public.gtsq_in(cstring) OWNER TO nehpus;</p><p>--<br />-- Name: gtsq_out(gtsq); Type: FUNCTION; Schema: public; Owner: nehpus<br />--</p><p>CREATE FUNCTION gtsq_out(gtsq) RETURNS cstring<br />&nbsp; &nbsp; AS &#039;$libdir/tsearch2&#039;, &#039;gtsq_out&#039;<br />&nbsp; &nbsp; LANGUAGE c STRICT;</p><br /><p>ALTER FUNCTION public.gtsq_out(gtsq) OWNER TO nehpus;</p><p>--<br />-- Name: gtsq; Type: TYPE; Schema: public; Owner: nehpus<br />--</p><p>CREATE TYPE gtsq (<br />&nbsp; &nbsp; INTERNALLENGTH = 8,<br />&nbsp; &nbsp; INPUT = gtsq_in,<br />&nbsp; &nbsp; OUTPUT = gtsq_out,<br />&nbsp; &nbsp; ALIGNMENT = int4,<br />&nbsp; &nbsp; STORAGE = plain<br />);</p><br /><p>ALTER TYPE public.gtsq OWNER TO nehpus;</p><p>--<br />-- Name: gtsvector; Type: SHELL TYPE; Schema: public; Owner: nehpus<br />--</p><p>CREATE TYPE gtsvector;</p><br /><p>--<br />-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: nehpus<br />--</p><p>CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector<br />&nbsp; &nbsp; AS &#039;$libdir/tsearch2&#039;, &#039;gtsvector_in&#039;<br />&nbsp; &nbsp; LANGUAGE c STRICT;</p><br /><p>ALTER FUNCTION public.gtsvector_in(cstring) OWNER TO nehpus;</p><p>--<br />-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: nehpus<br />--</p><p>CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring<br />&nbsp; &nbsp; AS &#039;$libdir/tsearch2&#039;, &#039;gtsvector_out&#039;<br />&nbsp; &nbsp; LANGUAGE c STRICT;</p><br /><p>ALTER FUNCTION public.gtsvector_out(gtsvector) OWNER TO nehpus;</p><p>--<br />-- Name: gtsvector; Type: TYPE; Schema: public; Owner: nehpus<br />--</p><p>CREATE TYPE gtsvector (<br />&nbsp; &nbsp; INTERNALLENGTH = variable,<br />&nbsp; &nbsp; INPUT = gtsvector_in,<br />&nbsp; &nbsp; OUTPUT = gtsvector_out,<br />&nbsp; &nbsp; ALIGNMENT = int4,<br />&nbsp; &nbsp; STORAGE = plain<br />[/spoiler]</p><p>примерно вся база построена так</p><p>Суть при импорте через&nbsp; phpmyadmin , выдает ошибку #1193 - Unknown system variable &#039;client_encoding&#039;</p><p>Не известная переменая и так везде практически</p><p>Вопрос, возможно как то уже имеющую БД сконвентровать для Mysql? может есть скрипты какие то или еще что то</p>]]></description>
			<author><![CDATA[null@example.com (anonim2008)]]></author>
			<pubDate>Thu, 01 Apr 2010 14:41:16 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=11458#p11458</guid>
		</item>
	</channel>
</rss>
