Ticket #586 (closed Bug: fixed)

Opened 7 months ago

Last modified 6 months ago

Pgsql list_tables() shows only tables from schema public

Reported by: fleximus Owned by: zombor
Priority: trivial Milestone: 2.1.2
Component: Libraries:Database Version: SVN HEAD
Keywords: database, pgsql, schemas Cc:

Description

The fix: 

$sql    = 'SELECT table_schema || \'.\' || table_name FROM information_schema.tables WHERE table_schema NOT IN (\'pg_catalog\', \'information_schema\')';

Reference for Postgresql Schemas

Attachments

Pgsql-list_tables.patch (0.6 kB) - added by fleximus 6 months ago.
Patch to list all user tables

Change History

Changed 7 months ago by Shadowhand

  • owner changed from Shadowhand to zombor

Changed 6 months ago by zombor

Can you provide a patch for this? I have no idea what line this is for.

Changed 6 months ago by fleximus

Patch to list all user tables

Changed 6 months ago by zombor

  • status changed from new to closed
  • resolution set to fixed

Fixed in r2731.

Note: See TracTickets for help on using tickets.