Migration from Symfoware to PostgreSQL-Constructor functions

Started by Sachin Kotwalover 12 years ago3 messagesgeneral
Jump to latest
#1Sachin Kotwal
kotsachin@gmail.com

Hello

While migrating small application from Symfoware to PostgreSQL.
There are some constructor functions in Symfoware.
Which I unable to execute in Symfoware database.

If anyone knows how to execute constructor functions in Symfoware.
how to see list of system tables, functions, view and user defined tables,
functions, views.
Please reply.

-----
Thanks and Regards,

Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Migration-from-Symfoware-to-PostgreSQL-Constructor-functions-tp5766203.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Jayadevan M
maymala.jayadevan@gmail.com
In reply to: Sachin Kotwal (#1)
Re: Migration from Symfoware to PostgreSQL-Constructor functions

Hi,
System tables, views and most of the metadata can be retrieved from these
views -
http://www.postgresql.org/docs/9.2/static/information-schema.html
Regards,
Jayadevan

On Sun, Aug 4, 2013 at 2:48 PM, sachin kotwal <kotsachin@gmail.com> wrote:

Show quoted text

Hello

While migrating small application from Symfoware to PostgreSQL.
There are some constructor functions in Symfoware.
Which I unable to execute in Symfoware database.

If anyone knows how to execute constructor functions in Symfoware.
how to see list of system tables, functions, view and user defined tables,
functions, views.
Please reply.

-----
Thanks and Regards,

Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Migration-from-Symfoware-to-PostgreSQL-Constructor-functions-tp5766203.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3raghu ram
raghuchennuru@gmail.com
In reply to: Sachin Kotwal (#1)
Re: Migration from Symfoware to PostgreSQL-Constructor functions

how to see list of system tables, functions, view and user defined tables,
functions, views.

You can get more details from below URL:

Extracting META information from PostgreSQL
(INFORMATION_SCHEMA)<http://www.alberton.info/postgresql_meta_info.html&gt;

Thanks & Regards
Raghu Ram