Postgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names always start with ‘company’ and end with the company number. So there may be schemas like: public company1 company2 company3 … companynn An application always works with a single company. The search_path is specified … Read more
Is there any query available to list all tables in my Postgres DB. I tried out one query like: SELECT table_name FROM information_schema.tables WHERE table_schema=”public” But this query returns views also. How can i get only table names only, not views? 7 Answers 7
What is the best way to list all of the tables within PostgreSQL’s information_schema? To clarify: I am working with an empty DB (I have not added any of my own tables), but I want to see every table in the information_schema structure. 8 Answers 8
I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we use, the constraint has a different name. How do I check if there’s a constraint with the name FK_ChannelPlayerSkins_Channels. 14 Answers 14
I have 2-3 different column names that I want to look up in the entire database and list out all tables which have those columns. Is there any easy script? 1Best Answer 11 To get all tables with columns columnA or ColumnB in the database YourDatabase: SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN (‘columnA’,’ColumnB’) … Read more
