On 19.03.2013 10:19, [email protected] wrote:
I tried this, which will get the list of tables belong to 'XYZ' tablespace.CREATE TABLESPACE TBS1 OWNER access LOCATION '/u03/tbs'; --> OK Create table public.SinhVien ( MaSV text, TenSV text, Sodt int ) tablespace TBS1; --> OK Insert into public.SinhVien (MaSV,TenSV,Sodt) Values ('001','Nguyen Van',123456789),('002','Nguyen Ha',987654321); --> OK select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='TBS1'); relname ---------0 (0 rows) why's return 0 rows ? i don't know
You didn't quote the tablespace name in the CREATE TABLESPACE statement, so it's actually called tbs1, in lower case. Try:
select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='tbs1'); - Heikki -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
