[GENERAL] How to convert MS SQL functions to pgSQL functions

Hello, I am stuck while trying to convert/port a MS SQL server database to pgSQL. Here is the code of the function in MS SQL server: CREATE FUNCTION [dbo].[AccountGroupHierarchy] -- Description: statement> ( @groupId numeric(18,0) ) RETURNS @table_variable TABLE (accountGroupId NUMERIC(18,0))

[GENERAL] How to retrive List of Tables in a Database using...

Hello, I am new to pgSQL. I would like to know if there is a way to do the following using pure SQL: 1. Retrieve list of all Tables in a database 2. Retrieve list of all Functions, Triggers, Sequences, Views, etc. 3. Retrieve list of all Group Roles 4. Retrieve list of all Login Roles 5. Struct

Re: [GENERAL] How to retrieve List of Tables in a Database using...

Hello, Thanks everyone for your help. I really appreciate it. Yogi Yang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general