如题所述
1ãéè¿å½ä»¤è¡æ¥è¯¢
\d æ°æ®åº ââ å¾å°ææ表çåå
\d 表å ââ å¾å°è¡¨ç»æ
2ãéè¿SQLè¯å¥æ¥è¯¢
"select * from pg_tables" ââ å¾å°å½ådbä¸ææ表çä¿¡æ¯ï¼è¿épg_tablesæ¯ç³»ç»è§å¾ï¼
"select tablename from pg_tables where schemaname='public'" ââ å¾å°ææç¨æ·èªå®ä¹è¡¨çååï¼è¿é"tablename"å段æ¯è¡¨çååï¼"schemaname"æ¯schemaçååãç¨æ·èªå®ä¹ç表ï¼å¦ææªç»ç¹æ®å¤çï¼é»è®¤é½æ¯æ¾å¨å为publicçschemaä¸ï¼
\d æ°æ®åº ââ å¾å°ææ表çåå
\d 表å ââ å¾å°è¡¨ç»æ
2ãéè¿SQLè¯å¥æ¥è¯¢
"select * from pg_tables" ââ å¾å°å½ådbä¸ææ表çä¿¡æ¯ï¼è¿épg_tablesæ¯ç³»ç»è§å¾ï¼
"select tablename from pg_tables where schemaname='public'" ââ å¾å°ææç¨æ·èªå®ä¹è¡¨çååï¼è¿é"tablename"å段æ¯è¡¨çååï¼"schemaname"æ¯schemaçååãç¨æ·èªå®ä¹ç表ï¼å¦ææªç»ç¹æ®å¤çï¼é»è®¤é½æ¯æ¾å¨å为publicçschemaä¸ï¼
温馨提示:答案为网友推荐,仅供参考