From: | paddy carroll <paddy(dot)carroll(at)gmail(dot)com> |
---|---|
To: | Lee Keel <lee(dot)keel(at)uai(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: tables not in list |
Date: | 2007-07-30 20:24:20 |
Message-ID: | 8E11A996-3EE9-4196-8073-95B590372D54@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
put all your tables in a new table (public.tables)
select table_name from public.tables
where public.tables.table_name not in (select table_name from
information_schema.tables where table_catalog='postgres' and
table_type='BASE TABLE' and table_schema='public')
On 30 Jul 2007, at 20:31, Lee Keel wrote:
> Hi List,
>
> I have a list of table names and I am trying to confirm that they
> are all in my postgres db. But what I want returned is a list/
> array of ones that are in my list but not in the db. So for example:
>
> CREATE TABLE test
>
> (
>
> somecol integer
>
> ) WITHOUT OIDS;
>
> CREATE TABLE bar
>
> (
>
> barcol integer
>
> ) WITHOUT OIDS;
>
> Now if I were to have a list of table names that included 'test',
> 'bar', and 'foo', then how do I get 'foo' to return. Here is what
> I have, but it returns the ones that are in the list and I want the
> opposite of that.
>
> select array(
>
> select table_name::text from information_schema.tables where
> table_catalog='postgres' and table_type='BASE TABLE' and
> table_schema='public'
>
> and table_name = any (array['test', 'bar', 'foo']))
>
>
> Thanks in advance for any help on this.
>
> Lee
>
>
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom
> they are addressed. If you have received this email in error please
> notify the sender. This message contains confidential information
> and is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this
> e-mail.
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2007-07-30 20:44:36 | plperl syntax highlighting for vi |
Previous Message | Lee Keel | 2007-07-30 19:31:10 | tables not in list |